topic proc sql, join on multiple conditions in SAS Programming

proc sql, join on multiple conditions

Ivy — Wed, 20 Apr 2016 18:01:10 GMT

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;

Re: proc sql, join on multiple conditions

Ivy — Wed, 20 Apr 2016 18:07:29 GMT

Find the answers, I should use:

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

Re: proc sql, join on multiple conditions

ballardw — Wed, 20 Apr 2016 19:48:19 GMT

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:

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