I've written simple code to output a SAS dataset to a txt file. When I read the file back into SAS, there are incremental (mostly blank) records being added, from what I think are "goofy" characters that I can't see. How do I get SAS to ignore these characters when outputting the file?
Output code:
DATA _NULL_;
FILE "file:\output" delimiter='09'x DSD lrecl=60;
SET DATA;
PUT
@1 VAR1 $40.
@41 VAR2 10.
@51 VAR3 10.
;
RUN;
Please show the code you are using to read the data back in. I suspect the issue is going to be with either a missing or incorrect infile option or possible an extra option that is not needed.
You may need to provide a tad more detail than "goofy" and some example data from your Set Data; statement may help as well.
Also which operating system are you running?
With windows your file statment generates this error:
ERROR: A component of D:\Data\WORK\SAS Temporary Files\_TD9908\file:\output is not a directory.
likely from the FILE: bit.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.