Importing select_multiple data into SPSS

d
​ear ODKers,

We have developed a ​questionnaire that involves a few select_multiple
items. We plan to use SPSS to analyse the data. At the moment we are
following these steps for select_multiple questions but are not sure about
recoding and importing data in SPSS:

  1. multiple options answers coded as numbers, e.g. if someone lives with
    mother=1, father=2, and sister=4, the response will be =1 2 4
  2. we are downloading data from ODK Collect as a csv file
  3. after some cleaning/ preparation we are importing into SPSS

We are very excited to start analysing our data, but we are struggling with
importing the select_multiple answers into a dataset, without recording
them as binary (yes/no) variables in excel before importing to spss. Is
this the only way to do it, or is there any other way around it?

When possible, I have converted the *select_multiple *questions into a
group of select_one yes_no questions that show in the same screen through
the field-list function, but that is not possible for all of our
select_multiple questions.

many thanks in advance,
Elona

It's actually the only way that you can make sense of the data, I mean,
creating n dummy variables for n-choice multiple questions. What else can
you do or do you need?

··· On Tuesday, April 15, 2014 5:17:31 PM UTC+7, Elona Toska wrote: > > d > ​ear ODKers, > > We have developed a ​questionnaire that involves a few select_multiple > items. We plan to use SPSS to analyse the data. At the moment we are > following these steps for select_multiple questions but are not sure about > recoding and importing data in SPSS: > > 1. multiple options answers coded as numbers, e.g. if someone lives with > mother=1, father=2, and sister=4, the response will be =1 2 4 > 2. we are downloading data from ODK Collect as a csv file > 3. after some cleaning/ preparation we are importing into SPSS > > We are very excited to start analysing our data, but we are struggling > with importing the select_multiple answers into a dataset, without > recording them as binary (yes/no) variables in excel before importing to > spss. Is this the only way to do it, or is there any other way around it? > > When possible, I have converted the *select_multiple *questions into a > group of *select_one yes_no* questions that show in the same screen > through the field-list function, but that is not possible for all of our > *select_multiple* questions. > > many thanks in advance, > Elona >

You may need to create n variables, and script to break into part and can
be analyzed using multi response in spss.

··· On Tuesday, April 15, 2014 at 3:17:31 PM UTC+5, Elona Toska wrote: > > d > ​ear ODKers, > > We have developed a ​questionnaire that involves a few select_multiple > items. We plan to use SPSS to analyse the data. At the moment we are > following these steps for select_multiple questions but are not sure about > recoding and importing data in SPSS: > > 1. multiple options answers coded as numbers, e.g. if someone lives with > mother=1, father=2, and sister=4, the response will be =1 2 4 > 2. we are downloading data from ODK Collect as a csv file > 3. after some cleaning/ preparation we are importing into SPSS > > We are very excited to start analysing our data, but we are struggling > with importing the select_multiple answers into a dataset, without > recording them as binary (yes/no) variables in excel before importing to > spss. Is this the only way to do it, or is there any other way around it? > > When possible, I have converted the *select_multiple *questions into a > group of *select_one yes_no* questions that show in the same screen > through the field-list function, but that is not possible for all of our > *select_multiple* questions. > > many thanks in advance, > Elona >