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 Federation Server Document: SAS FedSQL Language Reference for SAS Viya Workbench
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 for SAS Viya Workbench
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 Viya Workbench: SQL Procedure User’s Guide
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 for SAS Viya Workbench
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 for SAS Viya Workbench
query Expression	table-expression-1 <set-operator table-expression-2> <set-operator table-expression-3 ...> Retrieves data from tables. Product: Base SAS Document: SAS Viya Workbench: SQL Procedure User’s Guide

Last updated: September 24, 2026