Rename columns in esttab

0
votes

Consider the following toy example using the community-contributed command esttab:

sysuse auto, clear
estpost tabstat  mpg price, statistics(count mean) columns(statistics) listwise 
esttab . , title("summary stats") cells("count(fmt(%5.0f)) mean(fmt(%5.0f))")

summary stats
--------------------------------------
                      (1)             

                    count         mean
--------------------------------------
mpg                    74           21
price                  74         6165
--------------------------------------

How can I change the column name from count to N?

1
stata

1 Answers

1
votes

Use the collabels() option:

sysuse auto, clear

estpost tabstat  mpg price, statistics(count mean) columns(statistics) listwise 

esttab . , title("summary stats") collabels("N" "Mean") ///
           cells("count(fmt(%5.0f)) mean(fmt(%5.0f))")

summary stats
--------------------------------------
                      (1)             

                        N         Mean
--------------------------------------
mpg                    74           21
price                  74         6165
--------------------------------------
N                      74             
--------------------------------------