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
How to predict values one standard deviation above the means. …
Residuals for each regression outputHi, I would like to predict the residuals for each regression separately. So instead of doing like t…
AIC weights calculation and recursive regressionHello everyone, I am working on a Time series analysis, using VECM models. I will need to compare mo…
Do File Error - Incomplete Command ExecutionHi All I am using Stata 13 (on a MacBook MacOS Catalina), I have an error in executing commands fro…
Survey weights in pooled dataHi, I am using for my analysis pooled survey data from five different countries. I would normally u…
Subscribe to:
Post Comments (Atom)
0 Response to desperately in need of helping with exporting sum stats table
Post a Comment