Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- SAS Procedures
- /
- No values in correlation matrix

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

07-05-2016 10:32 AM

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!

Accepted Solutions

Solution

07-06-2016
12:37 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to yael

07-05-2016 11:49 AM

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;
```

All Replies

Solution

07-06-2016
12:37 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to yael

07-05-2016 11:49 AM

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;
```