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
Related Posts with import delimited does not work..
Help needed: Automate extracting of dataHi all, I am using Stata 16 and I need some help in automating the process of extracting data. I am…
Wanted: New Home for Survey Sampling textsI've retired from professional work and I'd like to donate the stat books in my library to a good ho…
how to include random intercept in predicted margins and plot after mi estimate: mixedHi all, I've got a dataset of students in schools for which I've imputed 20 datasets, and I'm estim…
Table of Sums Without Collapse?Hi Stata Friends - I'm back with a question regarding creating a table of values. I want to ascerta…
How interpret subgroup analysis output not report heterogeneity statistics for some groups?I wonder how to interpret the following heterogeneity statistics for subgroup analysis Array …
Subscribe to:
Post Comments (Atom)
0 Response to import delimited does not work..
Post a Comment