Expressions Listed Alphabetically

< C N Q

Name	Syntax and Description
<sql-expression> Expression	::= constant \| [alias] column \| function \| (scalar-subquery) \| () \| {operator \| predicate} Produces a single value from a combination of symbols and operators or predicates. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
<sql-expression> Expression	::= constant \| [alias] column \| function \| (scalar-subquery) \| () \| {operator \| predicate} Produces a single value from a combination of symbols and operators or predicates. Product: SAS Federation Server Document: SAS FedSQL Language Reference
CASE Expression	CASE [case-expression] WHEN when-expression THEN result-expression ... [WHEN when-expression THEN result-expression] [ELSE result-expression] END Selects result values that satisfy search conditions and value comparisons. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
CASE Expression	CASE [case-expression] WHEN when-expression THEN result-expression ... [WHEN when-expression THEN result-expression] [ELSE result-expression] END Selects result values that satisfy search conditions and value comparisons. Product: SAS Federation Server Document: SAS FedSQL Language Reference
CASE Expression	CASE <case-operand> WHEN when-condition THEN result-expression <WHEN when-condition THEN result-expression ...> <ELSE result-expression> END Selects result values that satisfy specified conditions. Product: Base SAS Document: SAS SQL Procedure User’s Guide
COALESCE Expression	COALESCE(expression [, …expression]) Returns the first non-null value from a list of columns. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
COALESCE Expression	COALESCE(expression [, …expression]) Returns the first non-null value from a list of columns. Product: SAS Federation Server Document: SAS FedSQL Language Reference
NULLIF Expression	NULLIF(expression-1, expression-2) Returns a null value if the two specified expressions are equal; otherwise, returns the first expression. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
NULLIF Expression	NULLIF(expression-1, expression-2) Returns a null value if the two specified expressions are equal; otherwise, returns the first expression. Product: SAS Federation Server Document: SAS FedSQL Language Reference
query Expression	table-expression-1 <set-operator table-expression-2> <set-operator table-expression-3 ...> Retrieves data from tables. Product: Base SAS Document: SAS SQL Procedure User’s Guide

Last updated: September 16, 2026