BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
1 REPLY 1
Paige
Quartz | Level 8
You have a missing value in a correlation matrix. This happens because there is no data for that pair of variables. Which definitely leaves you with a very serious problem -- how do you estimate the correlation when you have no data?

Let me ask you this ... how would you estimate the mean of a variable if you had no data to go on? Same answer applies to correlation. Message was edited by: Paige

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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