At 11:42 AM -0500 7/15/08, Peck, Jon wrote:
>Try the count command and use ALL or x TO y to specify the variables to check.
Thanks, Jon. Will this work with string variables included in the
range? Can I specify (-8 or "-8") for the values to be counted?
>From: D.R. Wahlgren
>ReplyTo: D.R. Wahlgren
>Sent: Jul 15, 2008 2:28 AM
>Subject: [SPSSX-L] Search for a value in all variables?
>Is there a way to search for a specific value on *all* variables in a
>data set without naming every variable in the syntax commands? For
>example, if I want to locate every instance of a -8 (our code for a
>refusal) across all 500+ variables in my data set, how would I go
>I'd like to do two things: 1) identify the case and variable for each
>instance of a -8, and 2) create a new variable that simply flags the
>presence of at least one -8 on the case with a dichotomous (0/1)
>Oh, and to complicate it just a bit more, a small number of the
>variables are string. If they could be included in the search, that
>would be great, but I would be ok with omitting them from this search
>if there was a relatively simple way to do it (I'd rather not have to
>name them all on a DROP subcommand but will if necessary.)
>I'm using v16 for Mac.
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
For a list of commands to manage subscriptions, send the command