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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.