Matching regions

[kushiwije]

Hello,

I will illustrate my problem via an example. I have region1 which is my chosen region. I also have region2 thru region100. i.e. 99 other regions. I want to find the best match to region1 from the pool of region2 thru region100 based on some match variables that have different weights.

So match variables 1 thru 5: based on the following weights:
variable #1 - 30%
variable #2 - 30%
variable #3 - 30%
variable #4 - 30%
variable #5 - 30%

If anyone has any ideas on the most efficient way to do this using SAS, it's very much appreciated. Thanks!

 

[kdt82]

Hi kushiwije,

Can you provide a clearer example? How does your dataset look at the moment?

It would help us identify the crux of the problem if you can provide a brief illustration of how your data is, and how you want it to be.

Thanks