Programming the statistical procedures from SAS

Exclude Variables from being imputed in PROC MI

Reply
Frequent Learner
Posts: 1

Exclude Variables from being imputed in PROC MI

Hey all,

 

I'm trying to impute around 25 categorical variables using the fcs function. I have another 30-40 variables I want to use to help with the imputation but want them left as they are (i.e. don't fill in missing values). I want to do this mostly for computing time reasons. I won't actually be adding more than 5-6 of my explanatory variables into my final model so I don't need them to be complete. Once added to the variable statement missing values are automattically imputed, which takes forever. Is there a way to include variables in the MI process that are not actually imputed themselves in SAS 9.3? 

 

Thank you for any help you can give.

Respected Advisor
Posts: 2,655

Re: Exclude Variables from being imputed in PROC MI

This may seem like the long way around Robin Hood's barn, but you could set a flag variable in a datastep to say whether the variable in question is missing, then go ahead and impute using whatever method you wish.  After that, in another data step, use the flag variable to set the imputed value back to missing.

 

It just depends on how you want to use those variables.

 

Steve Denham

Occasional Contributor
Posts: 18

Re: Exclude Variables from being imputed in PROC MI

Did you ever figure out a solution to this issue? I am facing the same situation. I have close to 200 variables that I need to impute, most of which are ordinal. I am using FCS since it can handle continuous, ordinal, and discrete data. However, the full imputation model takes about three days to run. OUCH! Moreover, I have too many variables for my sample size (498). Consequently, the model was not able to impute several variables; basically, it could not impute the majority of continuous variables that also happened to have the highest missing response rate. Hence, I would like to break up the imputation in two parts: use MCMC for the continuous data and FCS for the ordinal and discriminant data. Unfortunately, I cannot see how to exclude variables from being imputed but still used them as predictors. How did you resolve this problem? There is no real advantage to using the method that was suggested to your question because it would not save runtime.

 

Cristian

Ask a Question
Discussion stats
  • 2 replies
  • 97 views
  • 2 likes
  • 3 in conversation