Hi,
I am trying to read a .dat file into SAS. Have done this before using the DATA step, but for some reason, it am unable to read this particular file. Opened it with a text file, and the data looks like a tab-delimited, so tried using PROC IMPORT. That didn't work either. Attaching a screenshot of the data file.
Data screen shot:
DATA step code snippet:
data tv.alco; infile "/folders/myfolders/Trial/alcohol.dat" firstobs= 22; input Region $ Alcohol Tobacco ; run;
PROC IMPORT snippet:
proc import datafile="/folders/myfolders/Trial/alcohol.dat" out = tv.alco dbms=dlm replace ; delimiter= '09'x ;startrow=22; run;
Any help is appreciated 🙂
Thanks! That worked. Also got to learn about the DSD option.
The log in case of the DATA step is below. Basically a bunch of invalid reads from the file.
The Notepad++ screenshot with all the hidden characters:
Thanks for your help! 🙂
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.