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/
