I am desperately looking for the solution on exporting the summary stats tables.
I typed commands as below and this table is produced.
estpost tabstat pwt_bc pwt_ac ct_bc ct_ac if emp_cd==0 | emp_cs==0 [aw=wt], by(dual) statistics(N mean sd p50 min max) col(stat)
esttab est1 using mydoc1.rtf, replace cells("N mean sd p50 min max")
Array
This is what I have in the stata, but in the table exported in document, it shows like this:
Array
So I tried this command below instead,
estpost tabstat pwt_bc pwt_ac ct_bc ct_ac if emp_cd==0 | emp_cs==0 [aw=wt], by(dual) statistics(N mean sd p50 min max) col(stat)
esttab est1 using mydoc1.rtf, replace cells("pwt_bc pwt_ac ct_bc ct_ac ct_ch")
and got this table like this:
Array
This table is what I want, but I want the X-axis and Y-axis switched. And I couldn't just get this. It took me several hours exploring online to find the commands but I failed.
Can anyone help me out on this?
My questions are:
1) I want to have the sum stats and the variables switched. Why do I just not get them right? I want to have the variables in cells.
2) Is there any other stata commands to produce sum stat tables with weight and export them easier? I tried asdoc but asdoc doesn't get me the weighted values. aweight didn't work.
Related Posts with desperately in need of helping with exporting sum stats table
Panel VARHello everyone. I am trying to apply a fixed effect estimation procedure on a panel var. The variabl…
Genetic Matching packageAnalogously to the GenMatch package from R, is there any package in Stata that runs the Genetic Matc…
Filter households' data from a censusHi everyone! I'm working on my Master's thesis and I need help. I'm working with census data, and I …
Count how many variables have more than a certain number of missing valuesHi Statalists! I'm stuck on a very simple task: I would like to count how many variables in my datas…
What does Stata do with margins when using weighted least squares?I was surprised to find that, with weight (or aweight), margins does not seem to compute the average…
Subscribe to:
Post Comments (Atom)
0 Response to desperately in need of helping with exporting sum stats table
Post a Comment