BookmarkSubscribeRSS Feed
brulard
Pyrite | Level 9

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

 

2 REPLIES 2
kiranv_
Rhodochrosite | Level 12

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;

Reeza
Super User

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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1444 views
  • 1 like
  • 3 in conversation