topic Re: writing a text file, end of line CR LF in SAS Programming

writing a text file, end of line CR LF

Taliah — Tue, 19 Jul 2022 13:25:40 GMT

Hello,

I'm writing a text file using the following code

filename out "file_name.txt";

data _null_;

set dataA end=eof;

file out;

outline= cats(var1, var2, var3,'09'x);

put outline;

if eof then put "last_line_txt.";

run;

I get a text file where at the end of each line there are CR LF LF

(created by the '09'x)

I need only CR LF (without the second LF)

How do I do that?

I tried 'ODOA'x instead of the '09'x, but that does not work.

Thank you!

Re: writing a text file, end of line CR LF

Kurt_Bremser — Tue, 19 Jul 2022 13:36:53 GMT

"09"x is a tab, not a LF. LF is "0A"x.

To manipulate the end-of-line, use the TERMSTR option:

file out termstr=CRLF;
outline= cats(var1, var2, var3);
put outline;

Re: writing a text file, end of line CR LF

Taliah — Tue, 19 Jul 2022 13:52:11 GMT

Works great, Thank you!

Re: writing a text file, end of line CR LF

Tom — Tue, 19 Jul 2022 16:09:19 GMT

If you want full control use the RECFM=N option on the FILE statement.

data _null_;
     set dataA end=eof;
     file out recfm=n ;
     outline= cats(var1, var2, var3,'0D0A'x);
     put outline;
     if eof then put "last_line_txt.";
run;

Is there some reason why you need to make the writing of a text file so complicated?

Why are you not writing the end of line characters on the last line of the file?