Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: esttab


From   Ana Gabriela Guerrero Serdan <ag_guerreroserdan@yahoo.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: esttab
Date   Sun, 2 Mar 2008 06:32:13 -0800 (PST)

Ok, I can actually transfer the data from text to
columns but needs to be done for each of file once its
produced. Is this the way to go? 


--- Ana Gabriela Guerrero Serdan
<ag_guerreroserdan@yahoo.com> wrote:

> Dear Stata users, 
> 
> Im trying to make some tables with esttab exported
> in
> excel. I have some problems getting the numbers fit
> into separate columns and rows as in the example:
> http://repec.org/bocode/e/estout/esttab.html
> 
> I also try to replicate this example and I cant get
> it
> look like in the website. 
> 
> sysuse auto
> eststo: quietly regress price weight mpg
> eststo: quietly regress price weight mpg foreign
> esttab using example.csv, scsv
> 
> 
> 
> I get the following in excel: 
> 
> ="";="(1)";="(2)";="(3)";="(4)";="(5)";="(6)"
>
="";="price";="price";="price";="price";="price";="price"
> 
>
="weight";="1.747**";="3.465***";="1.747**";="3.465***";="1.747**";="3.465***"
>
="";="(2.72)";="(5.49)";="(2.72)";="(5.49)";="(2.72)";="(5.49)"
> 
>
="mpg";="-49.51";="21.85";="-49.51";="21.85";="-49.51";="21.85"
>
="";="(-0.57)";="(0.29)";="(-0.57)";="(0.29)";="(-0.57)";="(0.29)"
> 
>
="foreign";="";="3673.1***";="";="3673.1***";="";="3673.1***"
> ="";="";="(5.37)";="";="(5.37)";="";="(5.37)"
> 
>
="_cons";="1946.1";="-5853.7";="1946.1";="-5853.7";="1946.1";="-5853.7"
>
="";="(0.54)";="(-1.73)";="(0.54)";="(-1.73)";="(0.54)";="(-1.73)"
> 
> ="N";="74";="74";="74";="74";="74";="74"		
> 		
> t statistics in parentheses		
> ="* p<0.05	 ** p<0.01	 *** p<0.001"
> 
> How can I get the values into separate rows and
> columns? 
> 
> Thanks, 
> Gaby 
> 
> 
> Gaby Guerrero Serdan 
> 
> Deparment of Economics
> Royal Holloway, University of London
> TW20 OEX
> Egham, Surrey
> England, UK
>
http://www.rhul.ac.uk/economics/About-Us/postgrads.html
> http://www.flickr.com/photos/49939890@N00/show/
> 
> Tel: +44 7912657259
> 
> 
>      
>
____________________________________________________________________________________
> Never miss a thing.  Make Yahoo your home page. 
> http://www.yahoo.com/r/hs
> *
> *   For searches and help try:
> *  
> http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
> 


Gaby Guerrero Serdan 

Deparment of Economics
Royal Holloway, University of London
TW20 OEX
Egham, Surrey
England, UK
http://www.rhul.ac.uk/economics/About-Us/postgrads.html
http://www.flickr.com/photos/49939890@N00/show/

Tel: +44 7912657259


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index