IS MISSING Predicate

Tests for a SAS missing value in a SAS native data store.

Syntax
Arguments
Details
Comparisons
Example
See Also

Syntax

expression IS [NOT] MISSING

Arguments

expression

specifies any valid SQL expression.

See <sql-expression>
FedSQL Expressions

Details

IS MISSING is a predicate that tests for a SAS missing value. IS MISSING is used in the WHERE, ON, and HAVING clauses. The IS MISSING predicate resolves to true if the result of the SQL expression is a SAS missing value and resolves to false if it is not a SAS missing value.
The IS MISSING predicate is valid only in use with SAS native data stores. Only DOUBLE and CHAR data types support missing values.

Comparisons

The IS NULL predicate tests for null values.

Example

Table: WORLDCITYCOORDS
select *
    from worldcitycoords 
      where city is missing;
SAS creates the following table:
IS MISSING Example Output Table
IS MISSING Example Output Table

See Also

Predicates:
IS NULL Predicate
<search-condition> in the SELECT Statement
Copyright © SAS Institute Inc. All rights reserved.