How to conditional delete a record?

Moyosrie — Mon, 23 Nov 2020 11:34:25 GMT

i need to delete the record after the record that has status ='y'

data out;
input source $2.  target $2. type $5.;
datalines;
a b temp
b c temp
c b temp
b d perm
;
run;

 

data out1( drop=type rename=(source=source1 target=target1));
set out(firstobs=2);
run;

data new;
merge out out1;
run;

 

data new1(keep=status source target type);
length status $10.  ;
set new ;
if target1=source and source1 =target and type ='temp'
then status = 'Y';
else status= 'n';
run;

Re: sas code

Moyosrie — Sun, 22 Nov 2020 09:10:06 GMT

after every 'y' status

Re: sas code

Ksharp — Sun, 22 Nov 2020 11:27:05 GMT

data want;
set new1;
if lag(status)='Y' then delete;
run;

topic How to conditional delete a record? in SAS Programming

How to conditional delete a record?

Re: sas code

Re: sas code