Hello, I tried to join two tables using left join, which is a one to mutiple joins based on the two conditions, however the date condition was not applied. I am wondering what is the reason. Thank you ! proc sql; create table temp1 as select a.PatientID, a.AdministeredDate, b.TestDate, b.TestResult, (a.AdministeredDate -b.testdate) as dif_admin_test from admindate as a left join wgt as b on a.patientid = b.patientid and (a.AdministeredDate -b.testdate) <= 7 order by patientid, AdministeredDate, TestDate; quit;
... View more