BookmarkSubscribeRSS Feed
Flip
Fluorite | Level 6

I have an ODS output to CSV.  The recipient of this file is complaining that there are 2 cariage returns at the end of the file.  Is there any simple way to remove those past the data lines?  Otherwise I may have to change this to a data _null_  to satisfy them.

Ods Listing Close;
Title;
Ods Csv File = "test.txt"  ;

  Proc Print  Data=Ab_Out Noobs;
  Run;

Ods Csv Close;

1 REPLY 1
ballardw
Super User

If you actual data is as simple as your example PROC EXPORT might be a solution. At least I haven't had it put extra lines at the end like ODS does in most of the flavors I've used so far.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 1090 views
  • 0 likes
  • 2 in conversation