Bookmark and Share

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 16:50:26 +0100

<> 

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index