Statalist


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

Re: st: RE: RE: outreg2 + excel + ***


From   Johannes Geyer <JGeyer@diw.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: RE: outreg2 + excel + ***
Date   Mon, 6 Oct 2008 15:00:58 +0200

I found the examples and documentation of the "estout suite" on this 
website very helpful:

http://repec.org/bocode/e/estout/esttab.html#esttab010


However, when it comes to Excel I would also recommend the user written 
command -xml_tab-. 
It generates xml-files, which helps a lot when transfering data between 
Stata and Excel. A very
 recent article in the Stata Journal describes that command:

http://econpapers.repec.org/scripts/redir.pl?u=http%3A%2F%2Fwww.stata-journal.com%2Farticle.html%3Farticle%3Ddm0037;h=repec:tsj:stataj:v:8:y:2008:i:3:p:374-389


Johannes


owner-statalist@hsphsun2.harvard.edu schrieb am 06/10/2008 14:23:08:

> As a private question from Bastian shows, my reply was too terse:
> 
> *********
> cap ssc inst estout
> 
> eststo clear
> 
> sysuse auto, clear
> eststo: reg pr w re tr, robust
> eststo: reg pr w re
> 
> esttab est1 est2 using myfile.csv,  star(* 0.10 ** 0.05 *** 0.01) csv
> replace
> ********
> 
> shows that you should clear the estimates with the second line in the 
code.
> If you have several -estimates- in memory, tell -esttab- explicitly 
which
> ones you want. Otherwise you get all by default, see the last line...
> 
> HTH
> Martin
> 
> 
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Martin Weiss
> Sent: Monday, October 06, 2008 1:07 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: RE: outreg2 + excel + ***
> 
> *************
> cap ssc inst estout
> 
> sysuse auto, clear
> eststo: reg pr w re tr, robust
> 
> esttab using myfile.csv,  star(* 0.10 ** 0.05 *** 0.01) csv replace
> **************
> 
> 
> HTH
> Martin
> 
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Bastian 
Steingros
> Sent: Monday, October 06, 2008 12:33 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: outreg2 + excel + ***
> 
> Hi Stata users,
> 
> I have  installed the updates for *outreg2*. 
> 
> I have a regression model like:
> 
> reg dep_var ind_var1 ind_var2, robust
> 
> After entering this command in stata, I obtained the standard stata
> regression table (I guess you what I mean)
> 
> Now, I want to put my results into MS EXCEL and I want to mark the
> coefficients with the widely known signs like *, **, *** indicating
> significance at the 10%, 5%, 1% level.
> 
> I guess it is possible to do so by using outreg2 but it seems that I do 
not
> understand how to use this command correctly. 
> 
> Is there anyone who knows what to do ?
> 
> Many thanks for your help!
> 
> Bastian
> 
> -- 
> Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen:
> http://www.gmx.net/de/go/multimessenger
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
> 
> 
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
> 
> 
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   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