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   "Austin Nichols" <austinnichols@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Transfering a large set of Stata tables into Excel
Date   Tue, 25 Nov 2008 17:34:42 -0500

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 <n.j.cox@durham.ac.uk> wrote:
> See -help extended_fcn- and -help summarize- then.
>
> Nick
> n.j.cox@durham.ac.uk
>
> 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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index