Restructuring dataset

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Thu May 07, 2015 11:23 am

Restructuring dataset

Postby CFSmith » Thu May 07, 2015 11:39 am

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.
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: Restructuring dataset

Postby GerineL » Thu May 07, 2015 11:57 am

can't you just restructure and then remove not present? that's probably easiest.

Who is online

Users browsing this forum: No registered users and 2 guests