Filter

[Rhonda Boorman]

Thanks to Listers help I have sorted out my filter problem.

I am now thinking that there must be a command that will filter cases according to certain conditions.  What I want to do is:
Filter out cases if var1 var2 var3 etc have a total of 2 or more missing data values (i.e. 97 98 99).

Any advice would be appreciated.

Thanks
Rhonda

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

[Art Kendall-2]

something like

compute myfilter = not (nmiss(var1 to var3) gt 2).

Art Kendall
Social Research Consultants

Rhonda Boorman wrote:

> Thanks to Listers help I have sorted out my filter problem.
>
> I am now thinking that there must be a command that will filter cases according to certain conditions.  What I want to do is:
> Filter out cases if var1 var2 var3 etc have a total of 2 or more missing data values (i.e. 97 98 99).
>
> Any advice would be appreciated.
>
> Thanks
> Rhonda
>
> ===================
> 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

[Melissa Ives]

Or

Compute myfilter=nvalid(var1 to varn) gt x.

Where n= the number of variables and x eq n-2.

This requires that there are valid responses to the full number or only
one missing.

Melissa

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Art Kendall
Sent: Saturday, February 16, 2008 7:01 AM
To: [hidden email]
Subject: Re: [SPSSX-L] Filter

something like

compute myfilter = not (nmiss(var1 to var3) gt 2).

Art Kendall
Social Research Consultants

Rhonda Boorman wrote:
> Thanks to Listers help I have sorted out my filter problem.
>
> I am now thinking that there must be a command that will filter cases
according to certain conditions.  What I want to do is:
> Filter out cases if var1 var2 var3 etc have a total of 2 or more
missing data values (i.e. 97 98 99).

>
> Any advice would be appreciated.
>
> Thanks
> Rhonda
>
> ===================
> 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


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 [phone] for assistance.

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