Linking two tables with multiple rules

itshere — Wed, 20 Jul 2016 02:52:43 GMT

Hi -

I have a table that has an start date and an end date and need to see if a call was made on the start date or the end date. this is my current query but it does not work.

rsubmit;
proc sql;
create table test.field1 as
select
A.*,
B.*
from test.rock A
left join test.paper B
on A.account = B.account
and A.start_date = B.call_date
or A.end_date = B.call_date
;
endrsubmit;

So ideally i want to get a table that shows me all the interactions I got that matched the start date and end date WITH the call_date(different table)

**the interactions are linked to Call_date which is a different table.

This is the error i got...

NOTE: The execution of this query involves performing one or more Cartesian product joins that
can not be optimized.
ERROR: A lock is not available for test.field
ERROR: Lock held by process 5229800

Re: Linking two tables with multiple rules

ChrisNZ — Wed, 20 Jul 2016 02:55:50 GMT

There shouldnt be a cartesian product if you write the boolean clause the way you mean it:

on A.account = B.account
and (A.start_date = B.call_date
or A.end_date = B.call_date)

topic Re: Linking two tables with multiple rules in SAS Programming

Linking two tables with multiple rules

Re: Linking two tables with multiple rules