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..
FrequencyHi everyone, I want to calculate the cumulative frequency of firms which have different identifiers …
Extracting slopes for each person from a dual intercept mixed modelI have run a dual intercept mixed model as such: Code: mixed relsat i.husband c.Htime i.wife c.Wt…
Newey-West HAC standard errors smaller than regress, robust onesHi all, I am running an ARDL model in the form: Code: reg y l.y x1 l.x1 x2 l.x2 After the esti…
Newey-West HAC standard errors smalle than robust onesHi all, I am running an ARDL model in the form: Code: reg y l.y x1 l.x1 x2 l.x2 After the esti…
Multilevel Modeling Analysis for Rare EventsI am currently trying to run a hierarchical logistic model in Stata using federal sentencing data. I…
Subscribe to:
Post Comments (Atom)
0 Response to import delimited does not work..
Post a Comment