Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: Transfering a large set of Stata tables into Excel


From   "Nick Cox" <[email protected]>
To   <[email protected]>
Subject   RE: st: Transfering a large set of Stata tables into Excel
Date   Tue, 25 Nov 2008 22:40:05 -0000

Austin didn't spell this out, so I will. Once you want the sd too, you
no longer can get away with the -meanonly- option of -summarize-. 

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Austin
Nichols
Sent: 25 November 2008 22:35
To: [email protected]
Subject: Re: st: Transfering a large set of Stata tables into Excel

Try e.g.

file open x using tmp.xls, write replace
local sets "cancer nlswork psidextract"
foreach d of local sets {
 webuse `d', clear
 file write x `"`d'"' _n _tab "Mean"
 file write x _tab "SD" _tab "Min" _tab "Max"
 foreach v of varlist _all {
  qui su `v'
  file write x _n "`v'" _tab (r(mean))
  file write x _tab (r(sd))
  file write x _tab (r(min))
  file write x _tab (r(max))
 }
 file write x _n _n
}
file close _all
!tmp.xls

On Tue, Nov 25, 2008 at 5:27 PM, Nick Cox <[email protected]> wrote:
> See -help extended_fcn- and -help summarize- then.
>
> Nick
> [email protected]
>
> Rachel
>
> One more question:  How would I modify the line:
>
> file write x _n "`v'" _tab "`: di %9.3g r(mean)'"
>
> if I wanted the mean, standard deviation, max and min of each variable
> on a separate line?  I'm sure I can find this in my data manual, but
> unfortunately, I've loaned it out.

*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index