filtering data

[jimjohn]

if i go to select cases and filter a variable by values, i can't seem to be able to filter a variable by more than 9 values. for example, i have a variable poolno that can take on many different values and i want to only keep records for which poolno is one of 15 specific values. does anyuone know how i can do this? thanks!

[Marks, Jim]

comp poolfilt = any(poolno,v1,v2,v3,...,v15).
filter by poolfilt.

if poolno is a string variable, the values need to be encloses in
apostrophes:
comp poolfilt = any(poolno,'v1','v2','v3',...,'v15').

AFAIK no limit on the number of values accepted

--jim

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
jimjohn
Sent: Thursday, February 14, 2008 12:28 PM
To: [hidden email]
Subject: filtering data

if i go to select cases and filter a variable by values, i can't seem to
be able to filter a variable by more than 9 values. for example, i have
a variable poolno that can take on many different values and i want to
only keep records for which poolno is one of 15 specific values. does
anyuone know how i can do this? thanks!
--
View this message in context:
http://www.nabble.com/filtering-data-tp15485025p15485025.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

[ViAnn Beadle]

Why can't you filter by more than 9 values? What steps do you take?

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
jimjohn
Sent: Thursday, February 14, 2008 11:28 AM
To: [hidden email]
Subject: filtering data

if i go to select cases and filter a variable by values, i can't seem to be
able to filter a variable by more than 9 values. for example, i have a
variable poolno that can take on many different values and i want to only
keep records for which poolno is one of 15 specific values. does anyuone
know how i can do this? thanks!
--
View this message in context:
http://www.nabble.com/filtering-data-tp15485025p15485025.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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