PROC SQL also supports the ANSI SQL function COALESCE. COALESCE accepts multiple column names of the same data type. The COALESCE function returns the first argument whose value is not a SAS missing ...

PROC SQL supports the SAS System's INFORMAT=, FORMAT=, and LABEL= modifiers ... and group data by any kind of mathematical expression (except those including summary functions) using ORDER BY and ...