=========================================================================
Date:         Tue, 25 Jul 2006 14:34:21 +0000
Reply-To:     Jeff Aquino <joems_jsa@hotmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Jeff Aquino <joems_jsa@hotmail.com>
Subject:      Re: Filter cases but keep SYSMIS cases
Comments: To: hmaletta@fibertel.com.ar
In-Reply-To:  <007101c6ac40$7df15450$f000a8c0@NOTEBOOK>
Content-Type: text/plain; format=flowed

I want to  unsubscribe from  the  group  thanks



jeff





>From: Hector Maletta <hmaletta@fibertel.com.ar>
>Reply-To: Hector Maletta <hmaletta@fibertel.com.ar>
>To: SPSSX-L@LISTSERV.UGA.EDU
>Subject: Re: Filter cases but keep SYSMIS cases
>Date: Thu, 20 Jul 2006 18:07:20 -0300
>
>Yet another way:
>RECODE VAR (SYSMIS=7)(6=8).
>RECODE VAR (7=6).
>SELECT IF VAR LE 7.
>Recoding the sysmis cases to 7 and then back to 6 is not necessary, indeed.
>But recoding them to 6 in the first RECODE may cause an error because at
>the
>same time the old 6 values are recoded to 8 (though I believe it will not
>cause any error, because recoding works from right to left), and leaving
>them at 7 after the first RECODE will leave the variable with a
>discontinuous sequence of values (1,2,3,4,5,7) which an
>obsessive-compulsive
>worker may not like.
>Hector
>
>-----Mensaje original-----
>De: Hector Maletta [mailto:hmaletta@fibertel.com.ar]
>Enviado el: Thursday, July 20, 2006 6:02 PM
>Para: 'Marta García-Granero'; 'SPSSX-L@LISTSERV.UGA.EDU'
>Asunto: RE: Filter cases but keep SYSMIS cases
>
>A simpler way is to select all cases with values other than 6:
>COMPUTE FLAG=1.
>IF (VARX =6) FLAG=0.
>SELECT IF FLAG=1.
>Hector
>
>
>-----Mensaje original-----
>De: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] En nombre de
>Marta
>García-Granero
>Enviado el: Thursday, July 20, 2006 11:59 AM
>Para: SPSSX-L@LISTSERV.UGA.EDU
>Asunto: Re: Filter cases but keep SYSMIS cases
>
>Hi Lyndon,
>
>(Untested syntax):
>
>SELECT IF ((var LT 6) OR (MISSING(var)).
>
>* (LT: Lower Than).
>
>
>Or...
>
>SELECT IF (var NE 6).
>
>* (NE: Not Equal).
>
>LR> I am trying to filter some cases out of a sample.  I am using a filter
>LR> variable that has 6 categories (1-6) and I want to keep all the cases
>with
>LR> codes 1-5 and the SYSMIS cases, but delete the cases with a code of 6.
>When
>LR> I use this syntax, SELECT IF(var<6), I lose all the SYSMIS cases.  Is
>there
>LR> a way that I can keep the SYSMIS cases?
>
>Regards,