SAS PROC SQL how to keep cases

proc sql;
create table in_tab12 as select *,
count(distinct laptopID) as duplic
from in_tab1
group by Referral_number
having duplic > 1;
run;

Leave a Reply