Creating dummy variables from multiple categorical variables

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Creating dummy variables from multiple categorical variables

mgura
Howdy,
I have 90 categorical variables. Each categorical variable has 28 possible values plus the system missing value.
I want to create 28 dummy variables corresponding to the 28 responses. I have tried to use do repeat :

Do repeat a=v1 to v90.
If a=1 dummy1=1.
If a=2 dummy2=1
.
.
If a=28 dummy28=1.
End repeat.

When I check against the built in multiple response function, the frequencies of my dummy variables are always off.

I would use the plug in but it only creates dummies for the values that are represented
Unfortunately most of the variables only have a portion of the possible responses represented.
Any input would be greatly appreciated.
Thanks,
Mike