filtering a missing

[Rodrigo Briceño-2]

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

[Gary Rosin]

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

[JKRockStomper]

SELECT IF (ISIN NE "").



From:
Rodrigo Briceño <[hidden email]>
To:
[hidden email]
Date:
03/08/2012 12:55 PM
Subject:
filtering a missing
Sent by:
"SPSSX(r) Discussion" <[hidden email]>



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




____________________

Notice of Confidentiality.

 This document is intended only for the use of the entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. Any distribution to anyone other than the intended recipient may be prohibited by law and is strictly forbidden. If you have received this communication in error, please contact the REJIS Help Desk immediately at 314-535-9497

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