Hello, I'm trying to import delimited a csv file, separated by commas. Please find a sample of 5 rows. I run
import delimited "asdf.csv", clear
OR
import delimited "asdf.csv", delimiter(",") clear
but Stata reads it in as if there is only one variable.. This is the first time I'm seeing this problem, and I'd greatly appreciate any and all comments. If you do list, it shows
+--------------------------------------------------------------------------------------------------------------------------------+
| v1 |
|--------------------------------------------------------------------------------------------------------------------------------|
1. | 33481,5,394539,637013,314748,,13433,BOBJ,12328X107 ,840,? ,2006-01-30 00:00:00,FR,4,0,1,-1,1.0,41.529701,100,4.50,.12,2006-0.. |
2. | 33481,5,394539,637013,314748,,13433,BOBJ,12328X107 ,840,? ,2006-01-30 00:00:00,FR,4,0,1,-1,1.0,41.529701,100,4.50,.12,2006-0.. |
3. | 33481,5,394539,637013,314748,,13433,BOBJ,12328X107 ,840,? ,2006-01-30 00:00:00,FR,4,0,1,-1,1.0,41.529701,100,4.50,.12,2006-0.. |
4. | 33481,5,394539,637013,314748,,1
so it certainly is delimited by commas.
Thanks so much for your time in advance!
Best,
John
0 Response to import delimited does not work..
Post a Comment