@Astounding, @KachiM, @Reeza Here is the program and datasets. The problem is I don't know how records in dat1 are releated to records in dat2. data dat1;
input patient_id $ code $ 10. code_startdate $ 12.;
cards;
A dermatitis 2015-10-05
A dermatitis 2015-10-09
;
run;
data dat2;
input patient_id $ code $ 10. treatment_startdate $ 12.;
cards;
A dermatitis 2014-10-08
A dermatitis 2015-10-07
;
run;
proc sql noprint;
create table t1 as
select a.patient_id,
a.code,
a.code_startdate,
b.treatment_startdate
from dat1 as a
full join dat2 as b
on a.patient_id = b.patient_id and
a.code = b.code;
/* where b.treatment_startdate > a.code_startdate;*/
quit;
... View more
