proc sql, join on multiple conditions

[Ivy]

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;

[Ivy]

Find the answers, I should use:

0<= (a.AdministeredDate -b.testdate) <= 7

[ballardw]

What makes you believe the data condition was not applied? Provide some example input data that duplicates the behavior.

You may be interested in attempting this:

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

where a.AdministeredDate -b.testdate <= 7
order by patientid, AdministeredDate, TestDate;
quit;