Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: RE: RE: RE: Estout question
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
Subject
st: RE: RE: RE: Estout question
Date
Wed, 17 Feb 2010 22:10:41 +0100
<>
BTW, you can run something like
*******
outsheet using "C:\Users\martin\Documents\Stata\myestfile.csv", comma
replace
!start C:\Users\martin\Documents\Stata\myestfile.csv
*******
afterwards to get this into spreadsheet format...
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Martin Weiss
Sent: Mittwoch, 17. Februar 2010 22:05
To: [email protected]
Subject: st: RE: RE: Estout question
<>
Here is an example using -ssc d parmest- by Roger Newson:
*******
sysuse auto, clear
logit foreign weight length rep78 headroom
parmest, saving(myfile, replace) es(N df_m r2_p) /*
*/ ids("Logit Model 1") /*
*/ ren(es_1 N es_2 df_m es_3 r2_p parm Variable)
logit foreign gear_ratio displacement turn mpg
parmest, saving(myfile2, replace) es(N df_m r2_p) /*
*/ ids("Logit Model 2") /*
*/ ren(es_1 N es_2 df_m es_3 r2_p parm Variable)
u myfile, clear
append using myfile2
drop stderr z
l, noo
*******
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Martin Weiss
Sent: Mittwoch, 17. Februar 2010 21:03
To: [email protected]
Subject: st: RE: Estout question
<>
Could be a case for -ssc d parmest- and friends...
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Jeff Schiman
Sent: Mittwoch, 17. Februar 2010 20:13
To: [email protected]
Subject: st: Estout question
Greetings,
I want to send regression results to excel in a restructured form that is
condusive with pivot tables (see below). Basically, I want my N and R-square
to appear in their own columns. Any help would be much appreciated.
What I have written thus far:
estout Model1 using example.txt, begin(Logit,Model 1,) ///
cells("b (fmt(3) label(Value)) p(label(P-Value)) ci_l(label(CI Low))
ci_u(label(CI High))") ///
stats(N df_m r2_p) ///
replace
estout Model2 using example.txt, append ///
begin(Logit,Model 2,) ///
cells("b(fmt(3) label(Value)) p(label(P-Value)) ci_l(label(CI Low))
ci_u(label(CI High))") ///
stats(N df_m)
This produces:
Logit Model 1 Value P-Value CI Low CI High
Logit Model 1 x1 1.236 0.003 0.435 2.038
Logit Model 1 x2 0.264 0.187 -0.128 0.656
Logit Model 1 x3 1.994 0.000 1.566 2.422
Logit Model 1 x4 0.192 0.431 -0.286 0.671
Logit Model 1 N 1172
Logit Model 1 df_m 32
Logit Model 1 r2_p 0.261
Logit Model 2 Model2
Logit Model 2 Value P-Value CI Low CI High
Logit Model 2 x1 2.597 0.004 0.844 4.35
Logit Model 2 x2 1.578 0.026 0.190 2.965
Logit Model 2 x3 2.136 0.003 0.724 3.548
Logit Model 2 x4 0.075 0.911 -1.228 1.378
Logit Model 2 N 1172
Logit Model 2 df_m 32
Logit Model 2 r2_p 0.203
What I want (all separate columns):
Type Model Variable Value P-Value CI Low CI High N df_m r2_p
Logit Model 1 x1 1.236 0.003 0.435 2.038 1172 32 0.261
Logit Model 1 x2 0.264 0.187 -0.128 0.656 1172 32 0.261
Logit Model 1 x3 1.994 0.000 1.566 2.422 1172 32 0.261
Logit Model 1 x4 0.192 0.431 -0.286 0.671 1172 32 0.261
Logit Model 2 x1 2.597 0.004 0.844 4.350 1172 32 0.203
Logit Model 2 x2 1.578 0.026 0.190 2.965 1172 32 0.203
Logit Model 2 x3 2.136 0.003 0.724 3.548 1172 32 0.203
Logit Model 2 x4 0.075 0.911 -1.228 1.378 1172 32 0.203
Thank you,
Jeff Schiman
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/