topic Re: Can Someone Please turn this into a SAS dataset?? in SAS Procedures

Can Someone Please turn this into a SAS dataset??

mahler_ji — Tue, 04 Nov 2014 21:52:15 GMT

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

Re: Can Someone Please turn this into a SAS dataset??

ballardw — Tue, 04 Nov 2014 22:01:20 GMT

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.

Re: Can Someone Please turn this into a SAS dataset??

art297 — Tue, 04 Nov 2014 22:30:33 GMT

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;

Re: Can Someone Please turn this into a SAS dataset??

mahler_ji — Wed, 05 Nov 2014 16:17:55 GMT

Thank you so much for your help!

This cleared it right up.

John