Suppose I have dataset have
which contains cross-correlations (obtained from a proc corr output):
<code> _NAME_ A B C
A 1 0.2 0.8
B 0.2 1 0.3
C 0.8 0.3 1
</code>
<code> _NAME_ A B C
A 1 0.2 0.8
B 0.2 1 0.3
C 0.8 0.3 1
</code>
_NAME_ A B C
A 1 0.2 0.8
B 0.2 1 0.3
C 0.8 0.3 1
I am trying to calculate the largest correlation value
<code> data want;
set have;
max_corr = max(of A B C);
run;
</code>
<code> data want;
set have;
max_corr = max(of A B C);
run;
</code>
data want;
set have;
max_corr = max(of A B C);
run;
However, this value is 1 for each row, which is expected as the correlation across the diagonal is 1. How can I adjust the code to show the largest correlation not equal to 1?
2