Missing variables count for each case (row)

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

Posts: 1
Joined: Mon Jun 30, 2014 2:35 am

Missing variables count for each case (row)

Postby sarsoor » Mon Jun 30, 2014 2:36 am

I would like to count the missing values per each case (each row) in different than just doing a frequency count which provides me with missing values per each variable. For example, let's say I have a data set that includes the questionnaires of 100 participants. For each participant, I would like to know how many questions they answered or how many questions they didn't answer (in this case counting the missing variables). Does that make sense? and if it does, do you have a solution?
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: Missing variables count for each case (row)

Postby GerineL » Mon Jun 30, 2014 8:43 am

Yes that makes sense, and luckily there is a very convienient solution for that: the COUNT function.

You can find this under
Transform -> count values within cases.

Put all your questions in the "variables" box, and give it a name.

If you click "if", you can enter what should be counted (e.g., all variables with 1, 2, 3 or 4; all cases with system missing or whatever you like).

you can paste this into syntax to use it later too.

Who is online

Users browsing this forum: No registered users and 1 guest