Help using Base SAS procedures

No values in correlation matrix

Accepted Solution Solved
Reply
Contributor
Posts: 69
Accepted Solution

No values in correlation matrix

Hello

 

I created a correlation matrix via PROC CORR and found that the variable FF, which is dummy variable, has no values with 3 other variables (which are continous variables). I attached here the result as I got

 

Any clue why this is happened?

 

Thanks a lot!

 

Correlation.png


Accepted Solutions
Solution
‎07-06-2016 12:37 AM
SAS Super FREQ
Posts: 3,752

Re: No values in correlation matrix

This would happen if your FF variable is constant. The formula for the Pearson correlation has a denominator that contains the variance of the two variables. A constant variable has variance=0, which makes the correlation coefficient undefined. For example:

 

data a;
set sashelp.class;
c = 1;    /* constant value */
run;

proc corr data=a;
run;

 

 

View solution in original post


All Replies
Solution
‎07-06-2016 12:37 AM
SAS Super FREQ
Posts: 3,752

Re: No values in correlation matrix

This would happen if your FF variable is constant. The formula for the Pearson correlation has a denominator that contains the variance of the two variables. A constant variable has variance=0, which makes the correlation coefficient undefined. For example:

 

data a;
set sashelp.class;
c = 1;    /* constant value */
run;

proc corr data=a;
run;

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 211 views
  • 0 likes
  • 2 in conversation