Hi
I am trying to retain value of aval (where ablfl=y)in base_ for same usubjid ,I am getting missing values
wht can be issue?
proc sort data = final3 out=final3_;
by usubjid avisit descending ablfl;
run;
data final4_;
set final3_;
by usubjid avisit descending ablfl;
retain aval_ base_;
if first.usubjid and ablfl='Y' then do;
aval_=aval;
end;
else aval_=aval_;
run;
![img.png img.png](https://communities.sas.com/t5/image/serverpage/image-id/20084i5656904FB3D16E18/image-size/large?v=v2&px=999)