Yes, I agree with your thoughts. My plan is to 1. get cluster centroid by using proc fastclus 2. reassign clusters, by trying to borrow records from nearest clusters if it is less than 10,000 and send records to other clusters if it is more than 10,000 to make it approximately the same size (10,000) within each cluster. But like you said, it will be an iterative messy approach. Because once we borrow counts from other clusters, the cluster centroid are prone to change accordingly, new cluster centrod might need to reassign. Thanks! ... View more

Thanks for your response, I have some questions about geodistance(): 1. what are the benefits of geodistance()? 1. does geodistance guarantee that there will be equal size population counts for each cluster? Because there are rural and urban values that have different density of longitude/latitude. How can we guarantee that after geodistance, we have same size counts for each cluster. Thanks! ... View more

Thanks for you response. Yes, the target is to keep each cluster the same size for analysis purpose. I am sorry, are you not able to see the SAS code? I can see it from my side. proc fastclus data=NY_BRONX maxclusters=10 list distance out=cluster_NB outseed=out_NB; mzb_indiv_id; longitude latitude; run; ... View more