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..
Dynamically rename variable (using "word()")I have a dataset that looks as follows: Code: clear input str7 index int data "EOSQ041" 42…
Compare multiple regression coefficients across regression modelsHi guys, I want to compare coefficients across two different regression models. I found a useful in…
Problem with -import dbase-I am using -import dbase- to convert a DBF file to DTA. However, it is replacing some of the non-mis…
Measuring change in logistic random effects modelHi! I am doing a longitudinal analysis on the effects of firm contexts/practices on employees' rela…
Pre-announcement driftDear Statalist, I would really apreciate any help/tips members have to offer on this topic. I am w…
Subscribe to:
Post Comments (Atom)
0 Response to import delimited does not work..
Post a Comment