IS MISSING Predicate

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

Syntax

Arguments

Details

Comparisons

Example

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 Predicate

Syntax

Arguments

expression

Details

Comparisons

Example

See Also