I want to select only those observations from a table (Final_lIst) which don't belong in any of the two other tables (supp_data and ntb_data)
Will this code work?
proc sql;
create table Final_list as
select * from final_list
where customer_number
not in
(select distinct customer_number from supp_data and ntb_data ) ;
quit;
You have the AND in the wrong place.
where customer_number not in (select distinct customer_number from supp_data)
and customer_number not in (select distinct customer_number from ntb_data)
Unfortunately not, but this may ... if it doesn't post the log.
proc sql;
create table Final_list as
select * from final_list
where customer_number
not in
(select distinct customer_number from supp_data union select distinct customer_number from ntb_data ) ;
quit;
You have the AND in the wrong place.
where customer_number not in (select distinct customer_number from supp_data)
and customer_number not in (select distinct customer_number from ntb_data)
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.