BookmarkSubscribeRSS Feed
paddyb
Quartz | Level 8

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

1 REPLY 1
novinosrin
Tourmaline | Level 20
if first.usubjid and ablfl='Y' then do;
aval_=aval;
end;
else aval=aval_;/*correction here i think*/
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1185 views
  • 0 likes
  • 2 in conversation