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;
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;