st: RE: Using "outsheet" and foreach again

["Marino, Jennifer" <jmarino@fhcrc.org>]

Juanita -

I think you're iterating too many times. Try this:

foreach file in oilgs chmcl bresr indgs fdbev perhh hlthc rtail media
trles telcm utils banks insur finsv {
use `file', clear
outsheet using bra`file'.xls , replace
}

Jen


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/