BookmarkSubscribeRSS Feed
mndatagirl
Calcite | Level 5

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;

1 REPLY 1
ballardw
Super User

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.

 

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

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!

Register now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1597 views
  • 0 likes
  • 2 in conversation