As a courtesy, please provide your sampla data in a data step form next time.
proc sql;
create table want as
select have1.*, have2.recorded_time, have2.dressing, have2.grooming
from have1, have2
where have1.dmrn = have2.dmrn
group by have1.dmrn
having min(abs(dx_date - recorded_time)) = abs(dx_date - recorded_time)
;
quit;
... View more
