Hey y'all,
I, for some reason, cannot get the attached txt file to turn into a SAS dataset. I do this all the time, but I am having some trouble with this one. I am using the following code:
proc import datafile = "/home/mit/mahler/Homework/LaptopSales.txt" out=mylib.LaptopSales dbms=dlm replace;
getnames= yes;
delimiter = ",";
run;
I have attached the file...
Thanks!
John
I think you have another problem besides specifying the wrong delimiter. The file appears to be unicode. I'd suggest trying the following:
filename thefile "/home/mit/mahler/Homework/LaptopSales.txt" encoding="unicode";
proc import datafile = thefile out=mylib.LaptopSales dbms=tab replace;
getnames= yes;
run;
And what is the specific problem? Error messages, post them. Unexpected result, describe it.
Though I suspect the issue is that you are attempting to read it as comma separated, delimiter="," when it looks like it is TAB delimited.
I think you have another problem besides specifying the wrong delimiter. The file appears to be unicode. I'd suggest trying the following:
filename thefile "/home/mit/mahler/Homework/LaptopSales.txt" encoding="unicode";
proc import datafile = thefile out=mylib.LaptopSales dbms=tab replace;
getnames= yes;
run;
Thank you so much for your help!
This cleared it right up.
John
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.