SAS PROC SQL

Get the number of distinct values.

proc sql;
create table temp2 as select *,
count(distinct ID) as duplic
from final.cleaned
group by Case_num;
run;