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 on April 23, and its replacement, statalist.org is already up and running.


[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" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
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: 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/


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