SAS-function is almost any SAS function. Functions are described in SAS Language Reference: Dictionary. The ANSI SQL function COALESCE is supported. summary-function is described in summary-function.

SQL Basics I: Data Queries—covers database terminology and the four basic query types. SQL Basics: SELECT statement options —covers the SELECT statement in detail and explains aggregate functions.