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 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 <martin.weiss1@gmx.de>:
>
> <>
>
>
> Omit the -scsv- option, which is designed for German versions of Excel...
>
>
>
> 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 17:07
> An: statalist@hsphsun2.harvard.edu
> 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 <martin.weiss1@gmx.de>:
>>
>> <>
>>
>> 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: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Kaspar Dardas
>> Gesendet: Mittwoch, 10. März 2010 16:45
>> An: statalist@hsphsun2.harvard.edu
>> 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 <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/
>>
>>
>> *
>> *   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