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
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)
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)
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.