merge 3 dichotomous variables into one nominal
Posted: Thu Sep 26, 2024 6:29 am
Hi,
sorry if my Question has been answered elsewhere. I may lack the wording for my problem and could not find a solution so far.
My survey system exports answers to nominal variables into seperate dichotomous variables, so e.g. option 1 becomes PD_JOB_1, option 2: PD_JOB_2, option 3: PD_JOB_3 and so on. They can either be single choice or multiple choice (as in this case). PD_JOB_4 in the screenshot can be ignored, it was an addon field used to input the workload in percentage in addition to checking PD_JOB_3.
I'm looking for a way to transform them into a nominal containing all options e.g. PD_JOB with values 1,2,3 for both single and multiple choice items.
I appreciate your help.
sorry if my Question has been answered elsewhere. I may lack the wording for my problem and could not find a solution so far.
My survey system exports answers to nominal variables into seperate dichotomous variables, so e.g. option 1 becomes PD_JOB_1, option 2: PD_JOB_2, option 3: PD_JOB_3 and so on. They can either be single choice or multiple choice (as in this case). PD_JOB_4 in the screenshot can be ignored, it was an addon field used to input the workload in percentage in addition to checking PD_JOB_3.
I'm looking for a way to transform them into a nominal containing all options e.g. PD_JOB with values 1,2,3 for both single and multiple choice items.
I appreciate your help.