Can Someone Please turn this into a SAS dataset??

[mahler_ji]

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

[ballardw]

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.

[art297 · Accepted solution]

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;

[mahler_ji]

Thank you so much for your help!

This cleared it right up.

John