Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[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 <[email protected]>
To
[email protected]
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 <[email protected]>:
>
> <>
>
> " 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: [email protected]
> [mailto:[email protected]] Im Auftrag von Richard Ochmann
> Gesendet: Mittwoch, 10. März 2010 15:38
> An: [email protected]
> 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
>
> [email protected] 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 <[email protected]>:
>> >
>> > <>
>> >
>> > -ssc d estout- has a routing -estpost-, which, in conjunction with
>> -esttab-, can do most of these things...
>> >
>> >
>> >
>> > HTH
>> > Martin
>> >
>> >
>> > -----Ursprüngliche Nachricht-----
>> > Von: [email protected] [mailto:owner-
>> [email protected]] Im Auftrag von Kaspar Dardas
>> > Gesendet: Mittwoch, 10. März 2010 10:42
>> > An: [email protected]
>> > 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/