IS NULL Predicate

Tests for a null value.

Syntax

Arguments

Details

Comparisons

Example

Syntax

expression IS [NOT] NULL

Arguments

expression

specifies any valid SQL expression.

See	<sql-expression>
	FedSQL Expressions

Details

IS NULL is a predicate that tests for a null value. IS NULL is used in the WHERE, ON, and HAVING clauses. The IS NULL predicate resolves to true if the result of the SQL expression is null and resolves to false if it is not null.

Comparisons

The IS MISSING predicate tests for SAS missing values in SAS native data stores.

Example

Table: WORLDCITYCOORDS

select city
   from worldcitycoords
      where latitude is not null;

SAS creates the following table:

IS NULL Example Output Table

IS NULL Predicate

Syntax

Arguments

expression

Details

Comparisons

Example

See Also