PROC SQL supports many more summary functions than required by the ANSI Standard for SQL. The ROLLBACK statement is not supported. The UNDO_POLICY= option in the PROC SQL statement addresses rollback.

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