BookmarkSubscribeRSS Feed
Fernando
Calcite | Level 5

Hi Collegues,

I have 750 variables related to customers’ transaction behavior, account balances etc.

I have reduced the number of variables using proc varclus. Then the representative variables in each cluster  were inputted into proc logistic to identify predictors that are associated with acquisition of bank products.

I have two specific questions.

1.       Should I standardize the input variables separately before inputting into proc varclus?

2.       I used the following statements. Is there any method that I can use so that I do not need to list down the name of all 750 variables?

proc varclus data=temp.dataset               outtree=tree      centroid                maxclusters=25;

var         a     b     c     d      e..............................................name of 750th variable ;

run;

Would really appreciate any ideas.

Mirisage

2 REPLIES 2
DLing
Obsidian | Level 7

VARCLUS is related to principle/centroid components, thus can be affected by the scale on which the variables are measured.

  1. Since you specified the CENTROID option, these are unweighted averages of the standardized variables (stated in documentation), you don't need to pre-standardize them.  To convince yourself, you can standardize them yourself and then run VARCLUS to see if the result is any different.
  2. The easiest way to specify all numeric variables is "var _numeric_;" which is a list of all numeric variables.  You can use the drop= option on the input dataset to remove a few variables if necessary "proc varclus data=xxx(drop=v1 v2 v3) centroid; var _numeric_;" if this saves you typing.
Fernando
Calcite | Level 5

Hi Dling,

Thank you very much for this very useful clarification.

Best regards

Fernando

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 Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1541 views
  • 0 likes
  • 2 in conversation