Statalist


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

Re: st: esttab


From   "Friedrich Huebler" <fhuebler@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: esttab
Date   Sun, 2 Mar 2008 13:47:18 -0500

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
<ag_guerreroserdan@yahoo.com> 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
>
>
> <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
*
*   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