Question

I have a set of 5 variables in an IBM SPSS Statistics data set. These variables, named Sport1 to Sport5, represent a multiple response set. Respondents to the survey could choose up to 5 responses, coded 1 to 15, which represent 15 sports in which they had participated. I can analyze the frequencies of the 15 sports across the 5 variables by declaring them as a Multiple Response set and running the Multiple Response procedure (Analyze->Multiple Response->Frequencies. However, I would like to create a set of 15 dichotomous (binary) variables that represent the presence or absence of each of the 15 codes among the original 5 multiple response variables. So, if a respondent had the code for cycling, 5, among the values in Sport1 to Sport5, then that respondent would have a 1 in the new variable Cycling. Otherwise the respondent would have a 0 in the new variable Cycling. How can I transform the 5 multiple response variables into a set of multiple dichotomy variables?