topic Re: Inserting Blank Rows in SAS Programming

Inserting Blank Rows

AbuChowdhury — Sun, 07 May 2017 12:18:48 GMT

Hi Experts,

I use the following code to insert a blank row for each observation:

data want;
set have;
output; /* Output real observation */
if mod(_n_,1)=0;
array allnums {*} _numeric_ ;
array allchar {*} _character_ ;
drop i;
do i=1 to dim(allnums); allnums{i}=.; end;
do i=1 to dim(allchar); allchar{i}=' '; end;
output; /* Output blank observation */

run;
options missing=' '; /* Display numeric missing as blank */

My question is: How can I insert two or more blank rows for each observation?

Another question is: How can I insert a blank row in the beginning of the dataset?

Thanks,

Abu Chowdhury

Re: Inserting Blank Rows

novinosrin — Sun, 07 May 2017 12:43:06 GMT

I find it incomprehensive to use if mod(_n_,1)=0, that is anyway going to be 0 for all iteractions when the denominator is 1.

Secondly, you could simply use call missing(of _all_) and output staments in one shot without having to declare and loop through array elements.

Best Regards,

Naveen Srinivaan

Re: Inserting Blank Rows

novinosrin — Sun, 07 May 2017 13:04:09 GMT

For example:

data want;

if 0 then set sashelp.class;

if _n_=1 then do;

call missing(of _all_);

output;

end;

set sashelp.class;

output;

call missing(of _all_);

output;

run;

Re: Inserting Blank Rows

Astounding — Sun, 07 May 2017 13:29:19 GMT

That's a good set of tools for the job. Notice also a simplifying possibility:

if 0 then set sashelp.class;

if _n_=1 then output;

Since the variables are already missing when _n_=1, you don't have to jump through that hoop of setting them to missing.

Re: Inserting Blank Rows

Reeza — Sun, 07 May 2017 13:55:47 GMT

Why do you nerd blank rows? This is a display issue, so maybe you can add the spaces using PROC REPORT.

Re: Inserting Blank Rows

Reeza — Sun, 07 May 2017 13:55:51 GMT

Why do you nerd blank rows? This is a display issue, so maybe you can add the spaces using PROC REPORT.

Re: Inserting Blank Rows

Ksharp — Mon, 08 May 2017 12:32:40 GMT

data class;
if _n_=1 then output;
set sashelp.class;
output;
run;

Re: Inserting Blank Rows

AbuChowdhury — Tue, 09 May 2017 11:45:54 GMT

Thanks to all of you for your suggestions.