SAS output is showing a blank row after Footer

Trishjais — Fri, 17 Apr 2020 09:21:49 GMT

Hi,

I am outputting 2 datasets into a pipe delimited txt file, the problem is I'm getting an additional empty row at the last line after the footer, I'm using following code, Please help.

options nobomfile missing='';

filename rec "/folder1/folder2/file..txt" 
		mod encoding= 'UTF-8';

data _null_;
file rec notitle dsd delimiter='|';
length lbl $200;
if _n_=1 then do;
	do lbl='HD','supplier',&run_date.,'1.0','0','';
	put lbl @;
	end;
put;
end;
do until(eof);
set have1 end=eof;
put ID1-ID123;
end;
run;

data _null_;
file rec notitle dsd delimiter='|';
length lbl $200;
set have2 end=eof;
put CC1-CC143;
if eof then do lbl= 'FT','supplier',&run_date.,&obs.;
put lbl @;
end;
run;

Re: SAS output is showing a blank row after Footer

Tom — Fri, 17 Apr 2020 19:36:40 GMT

SAS does NOT write any extra lines at the end of text files. Each line consists of characters followed by the end of line character(s). Which is the standard format for text files.

If you are looking at the file in an editor then the editor is displaying an extra line so you have some place to start appending new lines.

Or what ever program you are using to read the file is misinterpreting the end of line character(s) in the file as if they were "record" delimiters. Check with the manuals for that program whether they have an option to let them process normal text files.

Examples of other users that have been stuck with using such misguided programs.

https://communities.sas.com/t5/SAS-Data-Management/Text-File-Output-Node-generating-extra-line-at-end-of-file/td-p/491759

https://communities.sas.com/t5/ODS-and-Base-Reporting/Don-t-insert-blank-line-in-csv-file/m-p/130525#M10764

https://stackoverflow.com/questions/35463015/prevent-final-lf-crlf-when-writing-a-text-file/35464019#35464019

topic SAS output is showing a blank row after Footer in New SAS User

SAS output is showing a blank row after Footer

Re: SAS output is showing a blank row after Footer