A research assistant has a data set with 200+ survey question variables that is set up like this, Where "A1" is the question number. subject ModA1_na ModA1_no ModA1_yes ModA2_na ModA2_no ModA2_yes 1 1 0 0 0 0 1 2 0 1 0 1 0 0 3 0 0 1 1 0 0 4 0 1 0 0 0 1 She wants to combine the questions so that there is one variable for each question with 0,1,2 as options for NA, NO , YES. So for example: Take “ModA1_na”, “ModA1_no”, “ModA1_yes” and combine to form one variable called "ModA1" with three categories. Do you know of a way to do this without writing a step for each new variable? She has over 60 questions with 3 variables each created for each question.
... View more