IS TRUE Predicate

Tests for a true value.

Syntax

(expression) IS [NOT] TRUE

Arguments

expression

specifies any valid SQL expression.

See <sql-expression>
FedSQL Expressions

Details

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

Comparisons

The IS FALSE predicate tests for false values.

Example

Table: WORLDCITYCOORDS
select city
   from worldcitycoords
      where (latitude = 40) is true;
SAS creates the following table:
IS TRUE Example Output
IS TRUE Example Output
Last updated: February 23, 2017