Proc Varclus ODS table RSquare

[Data_Detective_23219]

This table is poorly structured for automating variable selection.

For a given cluster solution the cluster identification variable Cluster: for "Cluster 1.... Cluster N" is only populated for the first variable in that cluster.  The remaining variables have a blank in Cluster until the first variable in the next Cluster.  Can anyone share a prog to autopopulate all variables within a cluster with their cluster identifier?

Current:

NumberofClusters          Cluster           Variable

10                                   Cluster 1           Var1

10                                                            Var2

10                                                            Var3

10                                   Cluster 2           Var4

10                                                            Var5

10                                                            Var6

Change to:

NumberofClusters          Cluster           Variable

10                                   Cluster 1           Var1

10                                   Cluster 1           Var2

10                                   Cluster 1          Var3

10                                   Cluster 2           Var4

10                                   Cluster 2          Var5

10                                   Cluster 2          Var6