LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2008)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Sat, 5 Apr 2008 18:01:19 -0500
Reply-To:   "Peck, Jon" <peck@spss.com>
Sender:   "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:   "Peck, Jon" <peck@spss.com>
Subject:   Re: Select cases with a value located anywhere/large data set
Comments:   To: A W Willis <awright_willis@HOTMAIL.COM>
In-Reply-To:   A<200804052251.m35Akedd010694@malibu.cc.uga.edu>
Content-Type:   text/plain; charset="utf-8"

any(x, var5 TO var150).

HTH, Jon Peck

-----Original Message----- From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of A W Willis Sent: Saturday, April 05, 2008 4:51 PM To: SPSSX-L@LISTSERV.UGA.EDU 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 LISTSERV@LISTSERV.UGA.EDU (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 LISTSERV@LISTSERV.UGA.EDU (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


Back to: Top of message | Previous page | Main SPSSX-L page