Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Drop and reorder columns


    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.
    Click image for larger version

Name:	Screenshot 2023-07-28 103950.png
Views:	1
Size:	14.7 KB
ID:	1722090


    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
Working...
X