topic How can I insert rows? in SAS Procedures

How can I insert rows?

HDSimo — Thu, 15 Apr 2010 07:49:55 GMT

Hi ,
i have a dataset with variable "a" that has 3 values: 0, 1, 2. I want to insert rows for the missing values in a dataset like this:

data a;
input a b;
cards ;
0 1
1 2
2 3
0 1
2 5
0 3
1 4
...
...
;
run;
i want my output will be like this :

0 1
1 2
2 3
0 1
1 .
2 5
0 3
1 4
2 .
Thank you very much in advance

Simone

Re: How can I insert rows?

HDSimo — Thu, 15 Apr 2010 08:29:21 GMT

My solution...

data new; retain i -1;
if i=2 then i=0; else i=i+1;
set a;
if i = a then output;
else do;
a=i; b=0;output;
end;
run;

Simone

Re: How can I insert rows?

HDSimo — Thu, 15 Apr 2010 09:20:13 GMT

Arghhh! It doesn't work?
Help please!

Re: How can I insert rows?

Patrick — Thu, 15 Apr 2010 13:15:56 GMT

data Have;
input a b;
cards ;
0 1
1 2
2 3
0 1
2 5
1 1
2 1
1 3
;
run;

data want(keep=a b);
set have end=last;
retain counter 0 RetA RetB;
RetA=a;
RetB=b;
if counter>2 then counter=0;
do until( (counter>RetA and not last) or (last and counter>2));
if RetA=counter then
do;
a=RetA;
b=RetB;
end;
else
do;
a=counter;
call missing(b);
end;
output;
counter+1;
end;
run;

proc print data=want;
run;

HTH
Patrick