Announcement

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

  • Export summary statistics

    Hi,

    I would like to export summary statistics and have some difficulties in format.
    I want to keep the 'YEAR' in the columns and the outcomes by group in the rows

    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input float score byte urban float year
    85.75 1 2006
    59.24 1 2006
    65.92 0 2006
    79.75 0 2006
      .22 0 2006
    68.81 1 2006
    41.06 1 2006
    95.59 0 2006
     8.44 0 2006
    52.04 0 2006
    62.77 0 2006
    end
    This is the code I used:
    Code:
    egen group = group(urban year), label
    estimates clear
    estpost tabstat score_percentile, by(group) statistics(mean sd) columns(statistics) listwise 
    esttab using "score_percentile_urban.tex", main(mean) aux(sd) nostar unstack noobs nonote nomtitle nonumber
    I think I have to change the 'columns' but it didn't export anything to tex.

    Thank you so much in advance.
Working...
X