Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Antwort: Re: st: AW: Copying Stata (Table) results to Excel


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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index