Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Missing values export to SPSS

  • Frederique
  • Frederique's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 4 months ago #145604 by Frederique
Missing values export to SPSS was created by Frederique
Hi everyone,

I have a question regarding missing values. In Limesurvey when a respondent does not have to answer a question because the question skipped due to the conditions installed, you get an empty cell in SPSS. What I mean is that there is no difference between people who do not answer a question because they forgot for example and people who do not have to answer the question because it skipped. Is there any possible way in Limesurvey to change this, that you can get a different value for people who do not have to answer the question.

SPSS does not know which questions are skipped and which not. I think the only way in SPSS to deal with this issue is to select cases based on the previous questions.

Thank you in advance,

Best regards,

Frédérique
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 4 months ago #145606 by Joffm
Replied by Joffm on topic Missing values export to SPSS
Hi, Frédérique,
to avoid this you have to make questions mandatory.
So you are sure that questions will not be forgotten.
Of course - if you want - you have to add an answer option like "don't know" or "no answer", or...

This way you have a code in all questions which were displayed to the respondent and only questions which were skipped stay empty.

If I interpret your text (" think the only way in SPSS to deal with this issue is to select cases based on the previous questions.") I fear you ran into this problem after finishing the survey.

In this case, yes, you have to do it in SPSS by recoding data.
E.g. Q1=missing, if (gender=1) and (Q1="") , if Q1 was to be answered by males

Best regards
Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
More
6 years 3 months ago #162509 by MaloF
Replied by MaloF on topic Missing values export to SPSS
I'm just facing the same issue. I have raised a bug issue about it (tickey 13172) because this information exist in VV files so it should be accessible in SPSS.

Thanks,

Malick
The topic has been locked.
More
6 years 3 months ago #162510 by jelo
Replied by jelo on topic Missing values export to SPSS
Always good to put a link to the bugticket in the related thread.
bugs.limesurvey.org/view.php?id=13172

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose