Date:         Fri, 26 Jun 2009 16:40:16 +0200
Reply-To:     Marta García-Granero <mgarciagranero@gmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Marta García-Granero <mgarciagranero@gmail.com>
Subject:      Re: Selecting a case when there are mulitple entries/case
In-Reply-To:  <200906261434.n5QAkeBp022921@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi Alison:

If you really want to delete the unwanted cases, use:

SELECT IF ANY(EVENT,2,4,6).
EXE.

HTH,
Marta GG

Alison America wrote:
> I have data with multiple entries per case. I have a variable EVENT that
> has various numeric values. For each case, I want to keep the case that
> has EVENT= 2 or 4 or 6 but delete all other cases that do not have any one
> of those values.
>
> Can anyone suggest syntax that will do this for me?
>
>
>

--
For miscellaneous SPSS related statistical stuff, visit:
http://gjyp.nl/marta/

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