Data want;   set have; Output; If duration le 4 then do;    Basefund=’add_silver’;   output’    Basefund=’silver’;   output’    Basefund=’add_gold’;   output’    Basefund=’bronze’;   output’ End;       JIm ... View more

Hello Andres,   I was able to solve using sql, However was not too sure anout the accuray of results I got.   In the attachment, you can see DOC is changed between two data sets for the same user, additonall challenge would be if there is any mismatch for other date attributes or other attributes.   I need to identify only those users who have this descrpency.   Thanks ... View more

Try:   if centre in ('Shai','Hub','imen') and (mdy(3,01,1953) le Date_of_Birth le mdy(6,30,1974)) then status = 'pass'; ... View more

An array is better or you would need to use two transposes and merge the results. data want; set have; array metal(3) goldfund silver  platinum; array val(3) goldpremvalue silverpremvalue platinumpremvalue; do i=1 to 3; value=metal(i); premvalue=val(i); fund=vname(val(i)); output; end; drop gold: silver: platinum:; run; ... View more