Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: convert dta to csv


From   Kit Baum <[email protected]>
To   [email protected]
Subject   st: convert dta to csv
Date   Thu, 14 Dec 2006 20:14:08 -0500

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/




© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index