if command with missing values

[Aenni]

Hi there

I'm just trying to code a filter that takes the value of my Manip2 variable if the value in the CheckQ variable is missing, otherwise it should take the value of the CheckQ.

I tried it like this:

compute NestedFil.
do if missing(CheckQ) NestedFil=Manip2.
else NestedFil=CheckQ.
end if.

another option I thought of was this one:
do if (CheckQ = Sysmis).
compute NestedFil=Manip2.
else if NestedFil=CheckQ.
end if.

I guess there is a mistake how I address a missing value in the if statement.
Has someone experience with addressing missing values in an if statement?

Many, many thanks
Anna

[Kirill Orlov]

if (CheckQ = Sysmis)
is an illegal statement.
$sysmis keyword can be used in assignment such as
compute var = $sysmis
but not as a condition expression argument
Use sysmis() function instead

26.07.2017 10:24, Aenni пишет:

Hi there

I'm just trying to code a filter that takes the value of my Manip2 variable
if the value in the CheckQ variable is missing, otherwise it should take the
value of the CheckQ. 

I tried it like this:

compute NestedFil. 
do if missing(CheckQ) NestedFil=Manip2.
else NestedFil=CheckQ.
end if.

another option I thought of was this one:
do if (CheckQ = Sysmis).
compute NestedFil=Manip2.
else if NestedFil=CheckQ.
end if. 

I guess there is a mistake how I address a missing value in the if
statement. 
Has someone experience with addressing missing values in an if statement?

Many, many thanks
Anna



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/if-command-with-missing-values-tp5734570.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

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

[David Marso]

CLOSE.
Try:
DO IF MISSING(CheckQ).
COMPUTE NestedFil=Manip2.
ELSE.
COMPUTE NestedFil=CheckQ.
END IF.

OR:
More concisely:

COMPUTE NestedFil=SUM(MISSING(CheckQ)*Manip2,CheckQ).

Aenni wrote

Hi there

I'm just trying to code a filter that takes the value of my Manip2 variable if the value in the CheckQ variable is missing, otherwise it should take the value of the CheckQ.

I tried it like this:

compute NestedFil.
do if missing(CheckQ) NestedFil=Manip2.
else NestedFil=CheckQ.
end if.

another option I thought of was this one:
do if (CheckQ = Sysmis).
compute NestedFil=Manip2.
else if NestedFil=CheckQ.
end if.

I guess there is a mistake how I address a missing value in the if statement.
Has someone experience with addressing missing values in an if statement?

Many, many thanks
Anna

[MLIves]

Why not make NestedFil = to CheckQ then set missing to Manip2?

compute NestedFil=CheckQ.
If (missing(CheckQ)) NestedFil=Manip2.

M
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Aenni
Sent: Wednesday, July 26, 2017 3:25 AM
To: [hidden email]
Subject: [SPSSX-L] if command with missing values

Hi there

I'm just trying to code a filter that takes the value of my Manip2 variable if the value in the CheckQ variable is missing, otherwise it should take the value of the CheckQ.

I tried it like this:

compute NestedFil.
do if missing(CheckQ) NestedFil=Manip2.
else NestedFil=CheckQ.
end if.

another option I thought of was this one:
do if (CheckQ = Sysmis).
compute NestedFil=Manip2.
else if NestedFil=CheckQ.
end if.

I guess there is a mistake how I address a missing value in the if statement.
Has someone experience with addressing missing values in an if statement?

Many, many thanks
Anna



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/if-command-with-missing-values-tp5734570.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

________________________________

This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

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

[Jon Peck]

To elaborate on Kirill's answer,

It is legal to use sysmis in a conditional statement but as $sysmis.

if x = $sysmis...

but it is useless, because sysmis is not equal to any value - not even itself.  It's best to think of sysmis as a NaN - not a number.  Just because the value is unknown does not mean that it is equal to another unknown.  As Kirill said, the sysmis function tests whether a value is sysmis.

The only arithmetic properties that sysmis has is that sysmis * 0 = 0, sysmis / 0 = 0, and mod(0, sysmis) = 0.

On Wed, Jul 26, 2017 at 5:33 AM, Kirill Orlov <[hidden email]> wrote:

if (CheckQ = Sysmis)
is an illegal statement.
$sysmis keyword can be used in assignment such as
compute var = $sysmis
but not as a condition expression argument
Use sysmis() function instead

26.07.2017 10:24, Aenni пишет:

Hi there

I'm just trying to code a filter that takes the value of my Manip2 variable
if the value in the CheckQ variable is missing, otherwise it should take the
value of the CheckQ. 

I tried it like this:

compute NestedFil. 
do if missing(CheckQ) NestedFil=Manip2.
else NestedFil=CheckQ.
end if.

another option I thought of was this one:
do if (CheckQ = Sysmis).
compute NestedFil=Manip2.
else if NestedFil=CheckQ.
end if. 

I guess there is a mistake how I address a missing value in the if
statement. 
Has someone experience with addressing missing values in an if statement?

Many, many thanks
Anna



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/if-command-with-missing-values-tp5734570.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

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

[Aenni]

Many thanks to all you for the helpful explanations!
It worked out great and I'm learning a lot.

[PRogman]

Why does not $sysmis/0 generate  Division-by-0 Error? I don't understand why.
/PRogman

<quote author="Jon Peck">
...

The only arithmetic properties that sysmis has is that sysmis * 0 = 0, sysmis / 0 = 0, and mod(0, sysmis) = 0.

...

[David Marso]

I noted that as well.  Could Jon have intended
0 /sysmis  = 0.
I can't test the sysmis /0 idea at the moment.
<quote author="PRogman">
Why does not $sysmis/0 generate  Division-by-0 Error? I don't understand why.
/PRogman

Jon Peck wrote

...

The only arithmetic properties that sysmis has is that sysmis * 0 = 0, sysmis / 0 = 0, and mod(0, sysmis) = 0.

...

[Kirill Orlov]

$sysmis/0 gives error. So, it is all right with it.

26.07.2017 20:09, David Marso пишет:

I noted that as well.  Could Kon have intended
0 /sysmis  = 0.
I can't test the sysmis /0 idea at the moment.

Why does not $sysmis/0 generate  Division-by-0 Error? I don't understand
why.
/PRogman


Jon Peck wrote

...

The only arithmetic properties that sysmis has is that sysmis * 0 = 0,
sysmis / 0 = 0, and mod(0, sysmis) = 0.

...

-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/if-command-with-missing-values-tp5734570p5734577.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

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

[Bruce Weaver]

DATA LIST LIST / v1(F1).
BEGIN DATA
1
END DATA.
COMPUTE test1 = $sysmis*0.
COMPUTE test2a = $sysmis/0. /* sysmis/0 .
COMPUTE test2b = 0/$sysmis. /* 0/sysmis .
COMPUTE test3 = mod(0,$sysmis).
LIST.

>Warning # 511
>A division by zero has been attempted on the indicated command.  The result
>has been set to the system-missing value.
>Command line: 113  Current case: 1  Current splitfile group: 1


v1    test1   test2a   test2b    test3

 1      .00      .        .00      .00


Number of cases read:  1    Number of cases listed:  1


<quote author="David Marso">
I noted that as well.  Could Jon have intended
0 /sysmis  = 0.
I can't test the sysmis /0 idea at the moment.

PRogman wrote

Why does not $sysmis/0 generate  Division-by-0 Error? I don't understand why.
/PRogman

Jon Peck wrote

...

The only arithmetic properties that sysmis has is that sysmis * 0 = 0, sysmis / 0 = 0, and mod(0, sysmis) = 0.

...

[Jon Peck]

for the second one, I meant to say 0 / missing = 0

Quoted from the CSR

On Wed, Jul 26, 2017 at 10:12 AM, PRogman <[hidden email]> wrote:

Why does not $sysmis/0 generate  Division-by-0 Error? I don't understand why.
/PRogman


...

The only arithmetic properties that sysmis has is that sysmis * 0 = 0,
sysmis / 0 = 0, and mod(0, sysmis) = 0.

...



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/if-command-with-missing-values-tp5734570p5734576.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

--

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