topic Re: cluster size in New SAS User

cluster size

Deepai — Fri, 07 Feb 2020 17:51:14 GMT

Hello helping hands,

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.

Thanks

Re: cluster size

PGStats — Fri, 07 Feb 2020 18:25:58 GMT

You could use something like:

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.