hi,
I have a criteria that relies on the output from three joins to be able to execute. So currently, I perform my 3 joins in sql, then add a base sas statement as such:
data want;set have;
If product in ('MC1', 'MC2') and Status='CLOSED' and balance='' then delete;run;
Here is an example of current sql join, if someone has a tip to modify it to add the above?
proc sql; create table final as;
select *
from a left join status_table b
on id=id
inner join balance_table c
on id=id;QUIT;
(first table A contains PRODUCT) , thanks
may be something like this. I have not tested this
proc sql;
create table final as
select * from
(select *
from a left join status_table b
on id=id
inner join balance_table c
on id=id)a
where not(product in ('MC1', 'MC2') and Status='CLOSED' and balance='' );
quit;
Didn't test it but you should be able to just add a WHERE to your query.
proc sql;
create table final as
select *
from a
left join status_table b
on id=id
inner join balance_table c
on id=id
WHERE not (product in ('MC1', 'MC2') and Status='CLOSED' and balance='');
QUIT;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.