Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Kaspar Dardas <kaspar.dardas@googlemail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: Antwort: Re: st: AW: Copying Stata (Table) results to Excel |
Date | Wed, 10 Mar 2010 16:44:59 +0100 |
Hi together, thanks for all the valueable comments. I am almost there. Ok, esttab, cells("mean sd count") is giving me exactly what I need and what the result tabel shows (please see below). However, I still cant get this into xls. Whenever I use the same syntax with estout, cells("mean sd count") I get simply one row and all values written below. AUSTRIA mean sd count CAR1 .0009741 .0719617 717 mCAR1 .0004599 .0712832 717 CAR4 .009031 .1264223 717 mCAR4 .0075043 .120172 717 CAR20 .0338397 .1637965 717 mCAR20 .0316329 .1543022 717 CARn20 -.0046692 .2066714 717 mnCAR20 -.0016028 .1831262 717 However, I need to get this somehow to xls. estout is givinig me the below for each country, which is better than nothing but there must be some way to get esttab, cells("mean sd count") into Excel. Or am I wrong? Cheers guys! AUSTRIA CAR1 717 .0009741 .0719617 mCAR1 717 .0004599 .0712832 CAR4 717 .009031 .1264223 mCAR4 717 .0075043 .120172 CAR20 717 .0338397 .1637965 mCAR20 717 .0316329 .1543022 CARn20 717 -.0046692 .2066714 mnCAR20 717 -.0016028 .1831262 . . .- . Best & Thanks, Kaspar 2010/3/10 Martin Weiss <martin.weiss1@gmx.de>: > > <> > > " esttab, cells("mean count")" > > > Kaspar can also add the standard deviation to the -esttab- call: > > > ************* > esttab, cells("mean sd count") > ************* > > > > HTH > Martin > > > -----Ursprüngliche Nachricht----- > Von: owner-statalist@hsphsun2.harvard.edu > [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Richard Ochmann > Gesendet: Mittwoch, 10. März 2010 15:38 > An: statalist@hsphsun2.harvard.edu > Betreff: Antwort: Re: st: AW: Copying Stata (Table) results to Excel > > this should do it: > > *** > estpost tabstat CAR1 mCAR1 CAR4 mCAR4 CAR20 mCAR20 CARn20 mnCAR20 if > transactiontype == Buy, by(location) statistics(n mean sd) > columns(statistics) listwise > > esttab, cells("mean count") > *** > > also see: > http://repec.org/bocode/e/estout/estpost.html#estpost102 > > best, rich > > owner-statalist@hsphsun2.harvard.edu schrieb am 10.03.2010 11:42:31: > >> Hi, >> >> >> First, thanks Martin! >> >> However, after using the below estpost tabstat command: >> >> estpost tabstat CAR1 mCAR1 CAR4 mCAR4 CAR20 mCAR20 CARn20 mnCAR20 if >> transactiontype == Buy, by(location) statistics(n mean sd) >> columns(statistics) listwise >> >> I can only tab one of the stored e() values such as >> . estout e(mean) using "C:\data\msci\all\data\final_test.xls", replace >> (output written to C:\data\msci\all\data\final_test.xls) >> >> I would like to table all e()s next to each other in an xls sheet. >> Exactly as I can see it on Stata*s result window. I simply cant get a >> command like the below to work: >> >> estout e(mean) e(count) e(.......... using >> "C:\data\msci\all\data\final_test.xls", replace >> >> >> Best, >> >> Kaspar >> >> >> >> >> 2010/3/10 Martin Weiss <martin.weiss1@gmx.de>: >> > >> > <> >> > >> > -ssc d estout- has a routing -estpost-, which, in conjunction with >> -esttab-, can do most of these things... >> > >> > >> > >> > HTH >> > Martin >> > >> > >> > -----Ursprüngliche Nachricht----- >> > Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner- >> statalist@hsphsun2.harvard.edu] Im Auftrag von Kaspar Dardas >> > Gesendet: Mittwoch, 10. März 2010 10:42 >> > An: statalist@hsphsun2.harvard.edu >> > Betreff: st: Copying Stata (Table) results to Excel >> > >> > Hello together, >> > >> > >> > what is the most efficient method to copy results (table, tabstat >> > etc.) from Stata to Excel? >> > >> > There is lots of good stuff for regression results but I couldn't >> > really find anything for sum results, tab results, tabstat etc... >> > Is there any ado which will copy the results table frrom Stata to xls? >> > >> > Many thanks, >> > >> > Kaspar >> > * >> > * 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/ > > > * > * 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/