How to Identify Cases with Missing Data?

[Justin Meyer-3]

Hi SPSSlist,

 

I want to create a list containing identifying information for the cases
that are missing data for X variable. X variable has 999 entered where
there is missing data and 999 is listed as a discrete missing value. If
I filter for cases where X=999 and run frequencies for X, I get a
message that I have filtered out all of the cases. I could temporarily
recode X so that 999 is not a discrete missing value, but it seems like
there should be a better way.

 

What is the best way to create a list of cases with missing data?

 

Is there a tool in SPSS for identifying cases with data coded as
missing?

 

____________________________________

Justin Meyer

Researcher

Rowland Reading Foundation

____________________________________

====================To manage your subscription to SPSSX-L, send a message to
[hidden email] (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

[Maguin, Eugene]

Justin,

Do this

Missing values x().
Temporary.
Select if (x eq 999).
>>>whatever you want to do next.

Gene Maguin

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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

[Peck, Jon]

Rather than recoding or temporarily removing the missing property, use the test
missing(x)
if you want to include all user and system missing values, or, to test 999 itself,
test
Value(x) = 999.
The value function returns the value of its argument ignoring the missing property.
HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Justin Meyer
Sent: Tuesday, November 18, 2008 1:23 PM
To: [hidden email]
Subject: [SPSSX-L] How to Identify Cases with Missing Data?

Hi SPSSlist,



I want to create a list containing identifying information for the cases
that are missing data for X variable. X variable has 999 entered where
there is missing data and 999 is listed as a discrete missing value. If
I filter for cases where X=999 and run frequencies for X, I get a
message that I have filtered out all of the cases. I could temporarily
recode X so that 999 is not a discrete missing value, but it seems like
there should be a better way.



What is the best way to create a list of cases with missing data?



Is there a tool in SPSS for identifying cases with data coded as
missing?



____________________________________

Justin Meyer

Researcher

Rowland Reading Foundation

____________________________________

=======
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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