Exporting Tabstat in Stata

statistics stata summary
Ahmed Arif picture Ahmed Arif · Dec 28, 2016 · Viewed 10k times · Source

I am trying to export tabstat result from stata. I am using following commands. 

estpost tabstat x1 x2 x3 x4, by(country)
estout using Data\summary.csv

However, when I open the CSV file, I only find

country
b

in the CSV file. Please let me know if there is something wrong in the commands I am using.

Answer

Eric HB picture Eric HB · Dec 28, 2016

Answer coming from: http://repec.org/bocode/e/estout/estpost.html#estpost101b

by country: eststo: quietly estpost summarize x1 x2 x3 x4, listwise
esttab using summary.csv, cells("mean") label nodepvar

You can add different summary stats to cells, for example: cells("mean sd min max") would show the mean, standard deviation, minimum, and maximum for each x in each country.

Hope this helps

Related questions

Loop over string variables in R

When programming in Stata I often find myself using the loop index in the programming. For example, I'll loop over a list of the variables nominalprice and realprice: local list = "nominalprice realprice" foreach i of local list { summarize `i' twoway (…

Read More
Pairwise Correlation Table

I'm new to R, so I apologize if this is a straightforward question, however I've done quite a bit of searching this evening and can't seem to figure it out. I've got a data frame with a whole slew of …

Read More
R Language: How do I print / see summary statistics for sample subset?

These are some newbie questions about statistical programming for R for which I haven't been able to find an answer online. My dataframe is labeled "eitc" in the code below. 1) Once I've loaded in a data frame, I would like …

Read More