st: convert dta to csv

[Kit Baum <baum@bc.edu>]

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/