Missing values export to SPSS

More
1 year 4 months ago #145604 by Frederique
Frederique created the topic: Missing values export to SPSS
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

Please Log in or Create an account to join the conversation.

More
1 year 4 months ago #145606 by Joffm
Joffm replied the 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

Please Log in or Create an account to join the conversation.

More
3 months 1 week ago #162509 by MaloF
MaloF replied the 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

Please Log in or Create an account to join the conversation.

More
3 months 1 week ago #162510 by jelo
jelo replied the 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

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!