Missing values in logical expressions

In a simple relation, the logic is indeterminate if the expression on either side of the relational operator is missing. When two or more relations are joined by logical operators AND and OR, a missing value is always returned if all of the relations in the expression are missing. However, if any one of the relations can be determined, IBM® SPSS® Statistics tries to return true or false according to the logical outcomes. See the topic AND and OR logical operators for more information.

  • When two relations are joined with the AND operator, the logical expression can never be true if one of the relations is indeterminate. The expression can, however, be false.
  • When two relations are joined with the OR operator, the logical expression can never be false if one relation returns missing. The expression, however, can be true.