Select cases with a value located anywhere/large data set

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Select cases with a value located anywhere/large data set

A W Willis
I am having trouble with my version 16.0
I have a large dataset- 600,000 cases, 150 variables.  I want to identify
cases that have a value of "x" anywhere between variable#5 and variable
#150.  The "select cases if" option would require that I type in the
condition box: variable 5="x" OR variable 6="x" OR....variable 150="x".  Is
there a simple syntax way to do this?

Thanks.

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: Select cases with a value located anywhere/large data set

Peck, Jon
any(x, var5 TO var150).

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of A W Willis
Sent: Saturday, April 05, 2008 4:51 PM
To: [hidden email]
Subject: [SPSSX-L] Select cases with a value located anywhere/large data set

I am having trouble with my version 16.0
I have a large dataset- 600,000 cases, 150 variables.  I want to identify
cases that have a value of "x" anywhere between variable#5 and variable
#150.  The "select cases if" option would require that I type in the
condition box: variable 5="x" OR variable 6="x" OR....variable 150="x".  Is
there a simple syntax way to do this?

Thanks.

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