Date: Mon, 13 Jul 2009 15:14:44 -0500
Reply-To: Melissa Ives <mives@chestnut.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Melissa Ives <mives@chestnut.org>
Subject: Re: finding missing values
In-Reply-To: <200907122339.n6CAkmYr000796@malibu.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"
I've seen the suggestions to use DO REPEAT or COUNT.
I might use the NVALID function like this:
Compute nmiss=113-(NVALID(Q1 to Q113)).
But the other half of Talino's question is which ones are missing.
It seems to me that something like this might give what you want (a list of missing items per record).
The format for QMISS may need to be changed depending on how much missing data you have.
STRING QMISS (A50).
VECTOR Q=Q1 TO Q113.
LOOP #I=1 TO 113.
+ DO IF MISSING (Q(#I)).
+ COMPUTE QMISS=CONCAT(RTRIM(QMISS),",",STRING(#I,F3)).
+ END IF.
END LOOP.
EXECUTE.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Talino Bruno
Sent: Sunday, July 12, 2009 6:40 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: [SPSSX-L] finding missing values
I have a number of measures with 113 questions. I have set up my SPSS data window so that the first column is the subject Id and the rest are the individual quetsion numbers (e.g Q1...Q113) with applicable scores. When the subject did not answer a particular question it was left blank in the data window. How can I determine the amount of questions that were left unanswered by each subject? I need to know for each subject which questions they may have missed.
=====================
To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at (309) 827-6026 for assistance.
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
