Gaby, do not specify the -scsv- option. That is, type:
esttab using example.csv
The -scsv- option is for Excel versions that expect a semicolon
instead of a comma as the column separator in the CSV format (e.g. the
German version). I will change the example on
http://repec.org/bocode/e/estout/esttab.html since I guess it's too
confusing.
ben
On Sun, Mar 2, 2008 at 1:10 PM, Ana Gabriela Guerrero Serdan
<[email protected]> 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/
>
*
* 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/
