data t1;
input ID $ time1 : mmddyy10.;
format time1 mmddyy10.;
cards;
A 01/09/2015
A 02/16/2015
;
run;
data t2;
input ID $ time2 : mmddyy10.;
format time2 mmddyy10.;
cards;
A 01/29/2015
A 02/19/2015
;
run;
proc sql;
select b.*,a.time1
from t1 as a right join t2 as b
on a.id=b.id and b.time2 > a.time1
group by b.id,b.time2
having b.time2-a.time1=min(b.time2-a.time1);
quit;
... View more
