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

Accepted Solution Solved
Reply
Super Contributor
Posts: 371
Accepted Solution

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

Hi Everyone,

 

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

 

Thank you,

 

HHC


Accepted Solutions
Solution
‎01-25-2016 01:25 PM
Contributor
Posts: 38

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

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

View solution in original post


All Replies
Grand Advisor
Posts: 10,252

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

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?

Solution
‎01-25-2016 01:25 PM
Contributor
Posts: 38

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

[ Edited ]
data want;
set have end=eof;
output;
if eof then do;
	call missing (of _all_);
	output;
end; run;
Esteemed Advisor
Esteemed Advisor
Posts: 7,262

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

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 298 views
  • 1 like
  • 4 in conversation