I have 20,000 individuals in my dataset. All these individuals belong to 400 different clusters. I want to get how many people are there in each cluster. i want to get the cluster size in the same dataset. Sorry i am very new with SAS.
proc sql;
create table newTable as
select *, count(distinct individualId) as clusterSize
from myData
group by clusterId;
quit;
where individualId and clusterId are variables in your dataset.
PG
Register Today!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.