I have been working with correlation matrices off and on, without thinking about this aspect too much ( one indication that perhaps it is not very important), but I noticed the following ,and wondered if there is a way to change it ?
- The gradient options provide for a starting color and an ending color (I would assume it is from lowest to highest like we generally perceive measures)
- However, the actual gradient is shown based on strength - weak to strong - therefore for -0.95 (strong negative) and 0.95 (strong positive), the same green color is depicted
- While I still find it useful (it helps in basic inference of variable relationships ), wouldnt there be value in changing this to a three color gradient - something like red - white - green, so that
* anything close to 0 (weak or almost no correlation) is white
* large positive correlation values are higher on the green scale
* large negative values are higher on the red scale
Perhaps convention dictates the current gradient, but I thought I will put this as a suggestion anyways. I understand there will be some internal feature request mechanism at SAS so perhaps this has been dealt with already.
Thank you very much ! (and sorry for a late reply, it has been a while since I logged in last) - unfortunately display rules are disabled for a correlation matrix - I guess it is because of the gradient measure out there - I was wondering whether to try out a custom chart (and then import that custom chart) or either an external chart object - but haven't got around to doing the same. Also - the correlation matrix calculates coefficients on the fly so I wanted to avoid the data prep beforehand..... Thanks again !
Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.