topic distance between two clusters in SAS Procedures

distance between two clusters

hdg — Tue, 24 Sep 2013 19:32:36 GMT

i , I have a simple question I want to find the distance between clusters

I have a cluster data set

date cluster_id number

11/30/2000 1 7

12/31/2000 1 8

11/30/2000 2 6

12/31/2000 2 5

etc

Potentially 100 cluster_ids

I want to compute the euclidean distance between each cluster

for all dates and all cluster_ids

dist_i_j = sum(( number i - number j )^2)

The final output should look like

cluster_id with_cluster_id dist_i_j

1 2 10

2 1 10

I get the 10 finding the distance across all dates (in this example 2).

10 = (7-6)^2 + (8-5)^2 = 1+9 = 10
Thanks so much for your help!

Reeza — Tue, 24 Sep 2013 21:49:09 GMT

Your distance measure is squared euclidean distance by cluster joining by date.

I think proc distance or proc corr could be used or proc fastclus. There's always SQL.

proc distance will work with a few extra steps.

How many clusters are you likely to have, will you know that ahead of time or is it dynamic?

hdg — Wed, 25 Sep 2013 13:45:49 GMT

Thanks Reeza. yes the number of clusters is known before hand in the cluster data set