try the in operator     data test; set WORK.table1; where id in (&myid); run;     ... View more

data have; input years$; date=input(cats('01-',years),anydtdte.); yr=year(input(cats('01-',years),anydtdte.)); month=month(input(cats('01-',years),anydtdte.)); lagmonth=lag(month); cards; Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 ; proc sort data=have; by yr date ; run; data want; set have; by yr date; retain count; if first.yr then count=lagmonth; month2=coalesce(count+month,month); drop month yr count lagmonth date; run; ... View more

data want; length newx $20.; set have; by mycode; retain newx; if first.mycode then newx=''; if mytype ne '' then newx=catx(' ',newx,mytype); if last.mycode; drop mytype; run;   ... View more

data have; input Patient $ VisitDate $ Value Unit $ Type $; cards; A Jan12019 1 m Height A Jan12019 50 kg Weight A Jan52019 2 m Height A Jan52019 55 kg Weight ; proc sort data=have; by patient VisitDate; run; data want; set have; by patient VisitDate; retain height_; if first.VisitDate then height_=.; if type='Height' then height_=Value; if last.VisitDate then bmi=value/height_**2; output; if bmi ne . then do; type='BMI'; value=bmi; unit='kg/m2'; output; end; drop height_ bmi; run; ... View more