proc sql;
create table ADLB as
select
LB.USUBJID,
LBDTC,
LBTESTCD as PARAMCD,
LBSTRESN as AVAL,
EXSTDTC,
input(LBDTC, yymmdd10.) as ADT format = yymmdd10.,
case
when -5 <= (input(LBDTC, yymmdd10.) - input(EXSTDTC, yymmdd10.)) <= -1
and LBSTRESN ne . then 'YES'
else 'NO'
end as within5days
from LB as LB, EX as EX
where LB.USUBJID = EX.USUBJID
order by USUBJID, LBTESTCD, within5days, ADT;
quit;
Does this work?
... View more