Programming the statistical procedures from SAS

Multiple imputation with restrictions or constraints

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Multiple imputation with restrictions or constraints

I have some data in discrete choice format, and I have a question on using PROC MI for discrete choice data. I am using imputation to fill in some missing independent variables as well as the dependent variable, choice. The problem is that pairs of choices need to be mutually exclusive (one row of data is the chosen option, the other is the option not chosen), something that PROC MI does not take into account. Is there a way to enforce this condition? Should I be using a different method of imputing the data? Should I not bother imputing the dependent variable? Any advice is appreciated.


Accepted Solutions
Solution
‎09-22-2014 05:52 PM
New Contributor
Posts: 2

Re: Multiple imputation with restrictions or constraints

I will answer my own question if it is permitted. It may not be the most elegant solution.

To recap, my data looked like

pidchoicevar...
111...
101...
210...
200...
301...
310...
............

To successfully use PROC MI, I "rolled" the observations with the same pid into a single row, so that my input would look something like this

pidchoicevar1var2...
1111...
2100...
3210...
...............

for the same data as the first table. After PROC MI, I would split the rows into the format needed to use PROC MDC.

It turns out this was pretty trivial, I was just in a state of tunnel vision!

View solution in original post


All Replies
Solution
‎09-22-2014 05:52 PM
New Contributor
Posts: 2

Re: Multiple imputation with restrictions or constraints

I will answer my own question if it is permitted. It may not be the most elegant solution.

To recap, my data looked like

pidchoicevar...
111...
101...
210...
200...
301...
310...
............

To successfully use PROC MI, I "rolled" the observations with the same pid into a single row, so that my input would look something like this

pidchoicevar1var2...
1111...
2100...
3210...
...............

for the same data as the first table. After PROC MI, I would split the rows into the format needed to use PROC MDC.

It turns out this was pretty trivial, I was just in a state of tunnel vision!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 203 views
  • 0 likes
  • 1 in conversation