Using estpost and esttab for mutli-level data summary statistics

[Amanda Wyant]

Hello,
I want to complete summary statistics for my multilevel data - countries (level 2) households (level 1). I want to provide averages at the country-level. I am currently using the two commands in Stata 15.1.

estpost tabstat genderlaws genderviews foodinsecure, statistics (mean)by(countryyr)

esttab . using file.rtf, replace

estpost provides what I want but when I try to put it into an rtf file it disappears and only provides the n of the whole dataset - no summary statistics. Any suggestions would be appreciated.

[Andrew Musau]

esttab is from Stata Journal, authored by Ben Jann. The program was designed for estimation commands and not to output tables, but you can try something as below:

estpost tabstat genderlaws genderviews foodinsecure, statistics (mean)by(countryyr)
mat Means = e(genderlaws)\ e(genderviews) \e(foodinsecure)
mat Means= Means'
esttab mat(Means) using file.rtf, replace

[Attaullah Shah]

asdoc can easily export summary states and outputs from other Stata commands to a Word file. See this example

ssc install asdoc, replace
webuse grunfeld
asdoc tabstat invest mvalue kstock , stat(mean) by(company )