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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.