I would like to restructure my dataset (from wide to long), I have 10 symptom present/not present variables for each participant that I would like to turn into cases BUT I only want SPSS to create a case if the participant has indicated that they have experienced the symptom. So there would not necessarily be 10 new cases created for each participant - there could be anything from 0 to 10. I know how to restructure the data so that each of the symptom variables is given a row but I can't work out if it is possible to only have a row created if the symptom was present (coded 1).
I would really appreciate any help you can give! Thanks.