DATA Step, Macro, Functions and more

Missing Value Imputation

Reply
Contributor
Posts: 52

Missing Value Imputation

Hi Everyone,

 

I have some variables for which i have to impute the missing values. 

 

Please provide your comments as to what kind of techniques are available to perform this task, thanks

 

Regards,

Super User
Posts: 19,877

Re: Missing Value Imputation

Posted in reply to dkanand86

Look at PROC MI?

Respected Advisor
Posts: 4,935

Re: Missing Value Imputation

Posted in reply to dkanand86

You can replace missing values with (in approximate order of complexity):

 

  1. a constant (e.g. the mean, median, etc. of your variable)
  2. a predicted value based on other non missing variables (e.g. predict missing weight from the height)
  3. an interpolated value (in time series)
  4. a random value from your variable assumed distribution
  5. a set of random values from your variable assumed distribution (multiple imputation)
PG
Ask a Question
Discussion stats
  • 2 replies
  • 229 views
  • 0 likes
  • 3 in conversation