delete cases in SPSS

[Devon]

I want to delete all cases that have missing values on any variable. That
is, I want only cases that have values on all my variables. How do you do
that in spss? Can anyone help!? syntax or otherwise.

Thanks,
Devon

=====================
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

[Bruce Weaver]

Devon wrote

I want to delete all cases that have missing values on any variable. That
is, I want only cases that have values on all my variables. How do you do
that in spss? Can anyone help!? syntax or otherwise.

Thanks,
Devon

If all of the variables are numeric, you can use the NMISS function.  Something like:

select if nmiss(firstvar to lastvar) =0.
exe.

Replace "firstvar" and "lastvar" with the names of the first and last variables in your file.  I don't have SPSS on this PC, so I can't check, but you might be able to use the keyword ALL inside the parentheses too.  I.e.,

select if nmiss(all) =0.
exe.

[Richard Ristow]

At 09:52 PM 10/27/2010, Bruce Weaver wrote:

If all of the variables are numeric, you can use the NMISS function.
Something like:

select if nmiss(firstvar to lastvar) =0.
exe.

Yes. Except (to point this out from time to time) the 'exe.' statement is NOT necessary, nor helpful; and can slow processing significantly, for large files.
===================== 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