Date: Fri, 26 Jun 2009 16:40:16 +0200
Reply-To: Marta García-Granero <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Marta García-Granero <email@example.com>
Subject: Re: Selecting a case when there are mulitple entries/case
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
If you really want to delete the unwanted cases, use:
SELECT IF ANY(EVENT,2,4,6).
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:
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