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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.