topic Re: How to add a blank row at the end of the file in SAS Programming

How to add a blank row at the end of the file

hhchenfx — Mon, 25 Jan 2016 17:12:27 GMT

Hi Everyone,

Could you please help me to add a row of blank at the end of my file?

Thank you,

HHC

Re: How to add a blank row at the end of the file

ballardw — Mon, 25 Jan 2016 17:19:23 GMT

Is this a dataset (in which case you'll need to provide some strong reasons for adding a blank row) or a exported dataset or a report?

What have you currently attempted?

Re: How to add a blank row at the end of the file

DanZ — Mon, 25 Jan 2016 17:42:06 GMT

data want;
set have end=eof;
output;
if eof then do;
	call missing (of _all_);
	output;
end;
run;

Re: How to add a blank row at the end of the file

RW9 — Mon, 25 Jan 2016 19:16:51 GMT

Am with @ballardw here, there is no reason I can think of to have a blank row in a dataset, it will just mess up procedures on the data, could even affect results. What is the reasoning? If you want categories regardless of prescence, then use a template dataset, i.e. create a dataset with the combinations you need, and then merge that onto a results dataset.