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 17:28:05 +0100
Thats it, Martin!
Thanks a lot again. My output look as below:
mean sd count
AUSTRIA
CAR1 .0009741 .0719617 717
mCAR1 .0004599 .0712832 717
CAR4 .009031 .1264223 717
mCAR4 .0075043 .120172 717
Best,
Kaspar
2010/3/10 Martin Weiss <[email protected]>:
>
> <>
>
>
> 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/
>
*
* 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/