st: Re: creating a macro for files

[Kit Baum <baum@bc.edu>]

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.

Kit Baum, Boston College Economics
http://ideas.repec.org/e/pba1.html


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/