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]
AW: Antwort: Re: st: AW: Copying Stata (Table) results to Excel
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
Subject
AW: Antwort: Re: st: AW: Copying Stata (Table) results to Excel
Date
Wed, 10 Mar 2010 17:09:57 +0100
<>
Omit the -scsv- option, which is designed for German versions of Excel...
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[email protected]] Im Auftrag von Kaspar Dardas
Gesendet: Mittwoch, 10. März 2010 17:07
An: [email protected]
Betreff: Re: Antwort: Re: st: AW: Copying Stata (Table) results to Excel
Martin thanks a lot!
this looks better, however, everything is weirdly separated now. How
can I set the export settings so its tab separated?
="AUSTRIA";="";="";=""
="CAR1";=".0009741";=".0719617";="717"
="mCAR1";=".0004599";=".0712832";="717"
="CAR4";=".009031";=".1264223";="717"
="mCAR4";=".0075043";=".120172";="717"
="CAR20";=".0338397";=".1637965";="717"
2010/3/10 Martin Weiss <[email protected]>:
>
> <>
>
> Try:
>
> *************
> sysuse auto, clear
>
> estpost tabstat price weight if rep78 == 3, /*
> */ by(foreign) statistics(n mean sd) /*
> */ columns(statistics) listwise
>
> esttab using myfile.csv, /*
> */ cells("mean sd count") replace /*
> */ scsv
>
> !myfile.csv
> *************
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected] [mailto:[email protected]] Im Auftrag von Kaspar Dardas
> Gesendet: Mittwoch, 10. März 2010 16:45
> An: [email protected]
> Betreff: Re: Antwort: Re: st: AW: Copying Stata (Table) results to Excel
>
> 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/
>
>
> *
> * 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/