Help using Base SAS procedures

Proc Varclus ODS table RSquare

Reply
Occasional Contributor
Posts: 14

Proc Varclus ODS table RSquare

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

Ask a Question
Discussion stats
  • 0 replies
  • 124 views
  • 0 likes
  • 1 in conversation