True. I was just following the questioner's example,
which then turned out to be not the problem at all.
Others have since made the same emendation without
comment.
Nick
[email protected]
Kit Baum
> It is also worth mentioning that if you name a file .xls,
> Excel might
> expect it to look like a binary spreadsheet file of type .xls. What
> outsheet creates is a text file, which you might name .txt, .csv,
> etc. Excel will probably be happier reading the file if you make it
> clear that it is a text file. Stata does not write Excel-compatible
> binary files.
> On Apr 20, 2006, at 2:33 AM, Nick wrote:
>
> >> local i = 1
> >> foreach file in oilgs data2 data3 {
> >> use `file', clear
> >> outsheet using bra`i'.xls
> >> local ++i
> >> }
*
* 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/