RAY said
You can do this in a csv ascii format with
outsheet y x1 x2 x3 using mycsv
but not an excel csv file.
Well, as much as Microsoft tries to create proprietary formats, I
don't think there is such an animal as an "excel csv file". A file with
data, data, data, "data", data etc.
is a CSV file. Excel thinks so; Stata (via -insheet- thinks so);
everyone agrees. It is not an "Excel csv file"; it is an ASCII CSV
file, but what other kind of CSV files can there be?
IMHO CSV files are a pain to deal with relative to tab-delimited
files, as it is much more common to have a comma within a field than
a tab. Both Excel and Stata are happy to work with tab-delimited files.
Kit Baum, Boston College Economics
http://ideas.repec.org/e/pba1.html
An Introduction to Modern Econometrics Using Stata:
http://www.stata-press.com/books/imeus.html
*
* 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/
