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/
