BookmarkSubscribeRSS Feed
esjackso
Quartz | Level 8

We are trying to figure out a way to group people in our state by location (actually zipcode lat, long), to find out where reps should be to be efficiently close in order to visit these people. Does anyone have any hints or tricks that they can share? We know how many reps we need in each region but not necessarily where they should be located. We have tried clustering on lat and long but dont get equal sized clusters.

Just interested if anyone has any insight they can share!

Thanks!

EJ

5 REPLIES 5
Reeza
Super User

Is that a cluster or minimization/optimization problem?

For example, minimize the distance between people and reps?

esjackso
Quartz | Level 8

We are actually trying to come up with a minimization of between people distances right now, we just dont know yet how it is going to turn out. We are manually writing the code for it so it taking some time to tweak and get it to  work.

Reeza
Super User

Yeah...ArcGIS is nicer for that kind of analysis, if you have it. But its pricey like SAS Smiley Happy

ballardw
Super User

By unequal cluster size to you mean the number of people to visit differs per rep? Unless you population is very homogenously distributed I would expect that given a geographic location for a rep.

Anyway, it may be helpful to show which clustering procedure code you used.

PGStats
Opal | Level 21

According to SAS doc, METHOD=COMPLETE in PROC CLUSTER gives you clusters biased toward equal cluster diameters and METHOD=WARD gives you clusters biased toward equal populations.

You will get more accurate distances if you translate lat-long coordinates into UTM X-Y coordinates (use a single zone, of course).

PG

PG

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 1226 views
  • 0 likes
  • 4 in conversation