SQL keep data when they also exist in another table

proc sql;
create table final.Cleaned_IN_tab3_edited as
select *
from li_tab3_ref_b2 as A
where exists (SELECT 1 from final.roster as B
where A.Referral_number=B.Referral_number);
run;

Leave a Reply