Gaby,
Save the results in tab-delimited format, then open the file in a text
editor, select all (Ctrl-A), and copy and paste everything to Excel.
The results will appear in separate rows and columns in Excel.
. esttab using example.txt, tab
Friedrich
On Sun, Mar 2, 2008 at 9:32 AM, Ana Gabriela Guerrero Serdan
<[email protected]> wrote:
> 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
>
>
> <[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/
> >
>
>
> 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
*
* 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/
