Date:         Thu, 8 Mar 2012 13:17:27 -0600
Reply-To:     Gary Rosin <grosin@stcl.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Gary Rosin <grosin@stcl.edu>
Subject:      Re: filtering a missing
In-Reply-To:  <CAAJU+h96BKC9kJVuLaz1u6LU4UjPQ6wF2fLiLsrYmUVL6yziKg@mail.g
              mail.com>
Content-Type: text/plain; charset="iso-8859-1"

Try the Missing function, which is a logical function that takes the
value 1 when the value is missing, and 1 when it is not:

DATASET ACTIVATE DataSet1.
USE ALL.
COMPUTE filter_$=(Not MISSING(ISIN)).
VARIABLE LABEL filter_$ 'NOT MISSING(ISIN) (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.



At 12:43 PM 3/8/2012, you wrote:
>Dear SPSS listers. I have a variable called ISIN. This variable is a
>string. Is there a way to filter the values of this variable that are
>not missing? As you may assume Missing values are "blank spaces".
>
>Thanks for your help!
>
>--
>Rodrigo Briceņo
>Economist
>rjbriceno@gmail.com
>MSN: jbric98@hotmail.com
>SKYPE: rbriceno1087
>
>=====================
>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

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