Programming the statistical procedures from SAS

Help with PROC MI (multiple imputation)

Reply
Contributor
Posts: 73

Help with PROC MI (multiple imputation)

Hi,

I am new to multiple imputation and I am trying to impute data in two different variables.

In my dataset I have 10 variables, 8 of them are complete and 2 contains missing data. Of these two, variable1 contains continous data and variable2 categorical (0/1).

About 20% of data for variable1 (continous data) is missing. Values in this variable(variable1) ranges from 1 to 70.

When I am imputing I recieve negative some values in variable1. I am probably doing something wrong in the settings fro PROC MI or can it be negative if all values are positive?

Thanks!

/Thomas

SAS Super FREQ
Posts: 3,310

Re: Help with PROC MI (multiple imputation)

The MCMC algorithm, which is the default method, assumes multivariate normality, which is why you are getting negative values. Look at the documentation for the TRANSFORM statement and hopefully you can choose a transformation that transforms your data to MVN.

Contributor
Posts: 73

Re: Help with PROC MI (multiple imputation)

Thanks!!

This worked!

Can I use the MCMC algorithm for categorical data as well or does MCMC only work for continous data?

/T

SAS Super FREQ
Posts: 3,310

Re: Help with PROC MI (multiple imputation)

A loooong time ago Paul allison wrote how to do this:

http://www2.sas.com/proceedings/sugi30/113-30.pdf

Since then, there have been a LOT of additions to PROC MI.  Look in the "Details" section of the doc for "imputing CLASS variables," such as here

SAS/STAT(R) 14.1 User's Guide

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