Try the Missing function, which is a logical function that takes the
value 1 when the value is missing, and 0 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
>
[hidden email]
>MSN:
[hidden email]
>SKYPE: rbriceno1087
>
>=====================
>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
=====================
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
Locked
