Help using Base SAS procedures

Can Someone Please turn this into a SAS dataset??

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 101
Accepted Solution

Can Someone Please turn this into a SAS dataset??

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


Accepted Solutions
Solution
‎11-04-2014 05:30 PM
PROC Star
Posts: 7,473

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

Posted in reply to mahler_ji

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;

View solution in original post


All Replies
Super User
Posts: 11,343

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

Posted in reply to mahler_ji

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.

Solution
‎11-04-2014 05:30 PM
PROC Star
Posts: 7,473

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

Posted in reply to mahler_ji

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;

Frequent Contributor
Posts: 101

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

Thank you so much for your help!

This cleared it right up.

John

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 311 views
  • 0 likes
  • 3 in conversation