Data transformation help needed: mv long to effect coded mv wide

stereotaxon

Hello,

I need help with a data transformation in RapidMiner or SQL, or something along these lines.
My data are in a DB, are categorical, and are in multivariate long format.  I need help converting them to
multivariate wide format and then effect coding the categories.

data::
sub1 q1.1  "subject1 responded 1 on q1, which has three choices"
sub1 q2.2  "subject1 responded 2 on q2, which has three choices"
sub2 q1.3  "subject2 responded 3 on q1, which has three choices"
.   "subject2 did not respond to q2"


Intermediary step (may not be necessary)
subject q1 q2
sub1 1 2
sub2 3      .


desired effect coded wide format data:
sub q1.1 q1.2 q1.3 q2.1 q2.2 q2.3
sub1 1 0 0 0 1 0
sub2 0 0 1 0 0 0

Thanks for your help!
-Mike

land

Hi,
I don't know any quick solution doing this. But you could write your own operator to do this, that's the way I would do it.

Greetings,
  Sebastian