Selecting a case when there are mulitple entries/case

[Alison America]

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?

Thanks

Alison

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

[Marta Garcia-Granero]

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