Hi, How to drop and reorder columns from a table generated by esttab ? Any help will appreciated.
Code:
gen group2 = . replace group2= 1 if groupA == 1 | groupB == 1 replace group2 = 0 if groupC == 1 global vars female resp_age hhsize estpost ttest $vars if group , by(group2) eststo estpost ttest $vars if group != 1, by(group) eststo esttab, cells("mu_1(fmt(%6.2f)) mu_2 b(star)")
After running the previous code, I get this table here with six columns. Now I want to remove the 5th column and move the third column to its place.
Mydata
Code:
* Example generated by -dataex-. For more info, type help dataex clear input float(id group group2 female resp_age) byte hhsize 1 1 1 1 38 5 2 2 1 1 53 2 3 1 1 1 45 3 4 1 1 1 50 4 5 1 1 1 34 4 6 3 0 1 38 4 7 1 1 1 25 5 8 3 0 1 21 3 9 1 1 1 26 4 10 1 1 1 49 3 11 3 0 1 32 4 12 3 0 0 55 2 13 1 1 1 28 5 14 3 0 0 40 4 15 1 1 1 31 4 16 3 0 1 43 2 17 1 1 1 50 7 18 1 1 1 65 4 19 1 1 1 28 7 20 1 1 1 59 4 21 1 1 1 56 4 22 3 0 0 51 3 23 3 0 0 34 3 24 1 1 1 38 4 25 1 1 1 50 6 26 3 0 1 27 5 27 1 1 1 40 4 28 3 0 1 45 4 29 3 0 1 37 5 30 1 1 1 24 6 31 3 0 1 58 2 32 2 1 1 56 5 33 2 1 1 28 3 34 3 0 1 56 1 35 1 1 0 45 3 36 1 1 1 20 4 37 2 1 1 54 3 38 1 1 1 40 6 39 3 0 0 50 3 40 2 1 1 55 2 41 2 1 1 60 1 42 1 1 1 45 4 43 2 1 1 30 3 44 2 1 1 53 2 45 2 1 1 24 6 46 3 0 0 43 3 47 3 0 0 28 4 48 3 0 1 21 7 49 3 0 1 60 5 50 1 1 1 45 3 51 2 1 1 54 10 52 2 1 1 75 1 53 2 1 1 55 4 54 1 1 0 47 2 55 2 1 1 38 4 56 3 0 0 53 5 57 3 0 0 28 3 58 2 1 1 41 4 59 3 0 1 60 3 60 2 1 1 51 4 61 1 1 1 55 3 62 2 1 1 40 5 63 2 1 1 41 3 64 3 0 1 54 3 65 2 1 1 42 4 66 2 1 0 43 4 67 3 0 0 46 5 68 1 1 1 43 3 69 2 1 1 50 4 70 3 0 1 50 2 71 2 1 0 42 1 72 1 1 1 25 4 73 1 1 1 30 4 74 3 0 0 27 5 75 2 1 1 44 4 76 1 1 1 35 4 77 1 1 1 39 4 78 1 1 1 50 2 79 1 1 1 43 4 80 2 1 1 55 1 81 1 1 1 28 4 82 2 1 1 48 5 83 1 1 1 42 3 84 3 0 1 37 4 85 3 0 0 27 3 86 1 1 1 40 5 87 1 1 1 52 6 88 3 0 1 23 2 89 3 0 1 23 3 90 1 1 1 47 5 91 1 1 1 42 2 92 1 1 1 45 3 93 1 1 1 48 5 94 3 0 1 55 3 95 1 1 1 52 2 96 1 1 1 52 4 97 1 1 1 53 4 98 3 0 0 32 2 99 1 1 1 40 5 100 2 1 1 30 4 end label values group gr label def gr 1 "JC and working", modify label def gr 2 "JC no work", modify label def gr 3 "No JC", modify