Re: Syntax failing to give result in one command

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: Syntax failing to give result in one command

Javier Figueroa
Hello 
Possibly you have some missing values ​​in the variable E, then do not take into account, try adding (E <1) OR MISSGING (E).

I hope you serve.


2014-05-07 23:00 GMT-06:00 ECL <[hidden email]>:
Hi all

When I run this request
IF(Q17>3 & Q20>2 & Q19>1 & Q5<3 & Q8<3 & Q23=0 & Q18=1) B1b=1.
Execute.

I get the correct result. B1b=1

However, earlier I computed the variable E

If I now run IF(Q17>3 & Q20>2 & Q19>1 & Q5<3 & Q8<3 & Q23=0 & Q18=1)AND
(E<1) B1b=1.
Execute.

Or IF(Q17>3 & Q20>2 & Q19>1 & Q5<3 & Q8<3 & Q23=0 & Q18=1)AND NOT (E=1)
B1b=1.
Execute.

I fail to get a B1b=1.

Yet if I run
IF(Q17>3 & Q20>2 & Q19>1 & Q5<3 & Q8<3 & Q23=0 & Q18=1) B1b=1.
Execute.
Then
IF(Q17>3 & Q20>2 & Q19>1 & Q5<3 & Q8<3 & Q23=0 & Q18=1)AND E<1 B1b=1.
Execute.
This gives me an accurate result of B1b=1.

Can anyone tell me why this is and how I can fix it. As I want to run my
syntax once only to generate the result.

THank you :)









--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Syntax-failing-to-give-result-in-one-command-tp5725903.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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



--
Javier Figueroa
Procesamiento y Análisis de bases de datos