Estimate missing correlation coefficient in a correlation matrix (please he

[deleted_user]

Good morning,
I have a scenario where i have been given a correlation matrix and in it i have many of the missing data. I would like to seek all of your help to please help me to figure out how could i do my best estimate in predicting those missing values in my correlation matrix.
I also would like to add that the correlation matrix contains non normalized data.
I have read SAS publication and i saw it offers an multiple imputation method for dealing with missing data. My question is :
1) Is IM dealing with only normalized data, but in my case, the matrix contains non normalized data.
2) Is IM only dealing with missing data, but in my case, I don't have a simple case of missing data, I have missing correlation coefficient in a correlation matrix. So could i use IM?

Thanks alot for all of your help,
Minh

[statsplank]

Hi Minh,

Correlation matrix is a simetric matrix. Do you have the same missing values on both sides of the main diagonal?

[statsplank]

.

[statsplank]

.

[statsplank]

.

[Doc_Duke]

The SAS PROC MI works only with missing data in the data table, it won't help you if you are starting with a correlation matrix and do not have the originating data. In fact, I don't think that there is a way to impute the missing correlations without the raw data.

If you have the raw data, then PROC MI can impute the missing data. It makes assumptions about the mechanism for the missingness (see the documentation for a discussion of that), but none about the underlying distribution in the data.

Doc Muhlbaier
Duke