BookmarkSubscribeRSS Feed
RobertF
Obsidian | Level 7

I'm performing a cluster analysis on a health insurance dataset (using proc distance and proc cluster) containing 4,343 observations with mixed continuous and binary variables.

 

I understand the importance of standardizing continuous variables. However, given the wide range of values for some of my continuous variables (notably outlier values for hospital visit counts and total medical expenses) I'm *still* seeing maximum z-score values of 15 or higher for standardized continuous variables compared with maximum values of 1 for unstandardized binary variables.

 

Should binary variables be standardized as well to prevent undue weight being placed on continuous variables?

 

For example, rare binary events such as MED_STROKE=1 (only 7 cases) would receive a standardized value of 24.9 given their "distance" from the mean value of MED_STROKE, which is close to zero.

 

3 REPLIES 3
ballardw
Super User

How much have you explored the options for the VAR statement in Proc Distance?

ballardw
Super User

How much have you explored the options for the VAR statement in Proc Distance?

RobertF
Obsidian | Level 7

I'm aware there are a range of standardization options - I'm considering calculating a simple z-score ( the std=Std option in the proc distnace var line) as a measure of the "distance" between the  x=0 and x=1 observations in binary variables.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1727 views
  • 0 likes
  • 2 in conversation