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

[hhchenfx]

Hi Everyone,

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

Thank you,

HHC

[ballardw]

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?

[DanZ · Accepted solution]

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

[RW9]

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.