Dear All, Can I please seek your help on how to combine this 2 proc sql together? The first proc sql is to obtaine the date of first and last treatment.
The second proc sql is to identify treatment emergent AE. Instead of two separate proc sql, how can I achieve this by using one proc sql? Thanks a lot.
proc sql;
create table txdat as
select id,
min(input(ECSTD,yymmdd10.)) format=is8601da. length=8 as trtstd,
max(input(ECEND,yymmdd10.)) format=is8601da. length=8 as trtend
from ec
group by id;
quit;
proc sql;
create table chk as
select coalesce (x.id,y.id) as id,
x.trtstd,
y.AEYN,
y.aeterm,
case when AESTDT <> "" then input(y.AESTDT,is8601da.) else . end as aestd format=is8601da. length=8,
case when AESTDT <> "" and trtstd <> . and calculated aestd >= trtstd then 1 else 0 end as teae,
y.tmp
from txdat as x
full join ae as y
on x.id=y.id;
quit;
... View more