topic Re: how to insert a blank row in a dataset in SAS Programming

how to insert a blank row in a dataset

knveraraju91 — Tue, 30 Oct 2018 20:06:49 GMT

Dear,

I need to insert two blank rows in my data set to use it for a graph. I am getting the output i need from data two, but is there a better way to program as there are more variables in actual data set. Thank you

output needed

a 1 c a
a

b 2 c a
c 3 c a
d 4 c a
e 5 c a
g 6 c a

data one;
input a $ b c $  d $;
datalines;
a 1 c a
b 2 c a
c 3 c a
d 4 c a
e 5 c a
g 6 c a
;

data two;
set one;
if _n_=1 then output;
if _n_=1 then do;b=.;c='';d='';output;end;
if _n_=1 then do;a='';b=.;c='';d='';output;end;
else output;
run;

Re: how to insert a blank row in a dataset

novinosrin — Tue, 30 Oct 2018 20:10:50 GMT

data two1;
set one;
if _n_=1 then do;
output;
call missing(b,c,d);
output;
call missing(of _all_);
output;
end;
else output;
run;

Re: how to insert a blank row in a dataset

PeterClemmensen — Tue, 30 Oct 2018 20:20:38 GMT

What kind of graph requires a blank row?

Re: how to insert a blank row in a dataset

ballardw — Tue, 30 Oct 2018 22:53:04 GMT

@PeterClemmensen wrote:

What kind of graph requires a blank row?

I am guessing one that the data is coming from a spreadsheet and is structured poorly for SAS graphing and this an attempt to translate spreadsheet graphing practices to a SAS graphic procedure.