what could be wrong?

[Rodrigo Briceño]

Dear SPSS listers. I'm running a syntax to get a new variable with mixed
conditional requisites:
compute new=0.
if Age<=14 & icd3<="A09" new=1.
execute.

Age is a numeric variable and icd3 is a string variable. When I manually
tried to compare results (filtering) I noticed that my syntax included
the missing values (defined as blanks). How can I avoid this, since I
need to build a longer set of conditionals?

Thanks.
--

__________________________________________________________________

*Rodrigo Briceño*
Project Manager
Sanigest Internacional

[phone] ext. 113  * Oficina* *Costa Rica*
[phone]                  *Fax
*[phone]*                  Celular**
*[hidden email] <mailto:[hidden email]>
www.sanigest.com <http://www.sanigest.com/>

MSN: [hidden email] <mailto:[hidden email]>
SKYPE: rbriceno1087

_____________________

This communication contains legal information which is privileged and
confidential. It is for the exclusive use of the address and
distribution, dissemination, copying or use by others is strictly
prohibited. If you have received this communication by error, please
delete the original message and e-mail us.


Esta comunicación contiene información legal privilegiada y confidencial
para el uso exclusivo del destinatario. La distribución, diseminación,
copia u otro uso por terceras personas es estrictamente prohibida. Si
usted ha recibido esta comunicación por error, le rogamos borrar el
mensaje original y comunicárnoslo a esta misma dirección.

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

[Albert-Jan Roskam]

Simple. Just add "& icd3 ne ' '" to your syntax line.
If I were you I would also create a frequency table of
your ICD code variable, just to check if it contains
any more unexpected values, i.e. indentations or
something like that. If the value is ' A99' (notice
the space!) it is included in your current syntax,
which you probably don't want.

Cheers!!
Albert-Jan

--- Rodrigo Briceño <[hidden email]> wrote:

> Dear SPSS listers. I'm running a syntax to get a new
> variable with mixed
> conditional requisites:
> compute new=0.
> if Age<=14 & icd3<="A09" new=1.
> execute.
>
> Age is a numeric variable and icd3 is a string
> variable. When I manually
> tried to compare results (filtering) I noticed that
> my syntax included
> the missing values (defined as blanks). How can I
> avoid this, since I
> need to build a longer set of conditionals?
>
> Thanks.
> --
>
>

__________________________________________________________________

>
> *Rodrigo Briceño*
> Project Manager
> Sanigest Internacional
>
> [phone] ext. 113  * Oficina* *Costa Rica*
> [phone]                  *Fax
> *[phone]*                  Celular**
> *[hidden email] <mailto:[hidden email]>
> www.sanigest.com <http://www.sanigest.com/>
>
> MSN: [hidden email]
> <mailto:[hidden email]>
> SKYPE: rbriceno1087
>
> _____________________
>
> This communication contains legal information which
> is privileged and
> confidential. It is for the exclusive use of the
> address and
> distribution, dissemination, copying or use by
> others is strictly
> prohibited. If you have received this communication
> by error, please
> delete the original message and e-mail us.
>
>
> Esta comunicación contiene información legal
> privilegiada y confidencial
> para el uso exclusivo del destinatario. La
> distribución, diseminación,
> copia u otro uso por terceras personas es
> estrictamente prohibida. Si
> usted ha recibido esta comunicación por error, le
> rogamos borrar el
> mensaje original y comunicárnoslo a esta misma
> dirección.
>
> =====================
> 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
>

      ____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

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