Undocumented and Hard-to-find PROC SQL® Features

The SQL Procedure contains many powerful and elegant language features for advanced SQL users. This paper presents SQL topics that will help programmers unlock the many hidden features, options, and other hard-to-find gems found in the SQL universe. Topics include CASE logic; the COALESCE function; SQL statement options _METHOD, _TREE, and other useful options; dictionary tables; automatic macro variables; and performance issues.

Paper: 

Kirk Lafler - Undocumented and Hard-to-find PROC SQL Features.pdf

Sample Programs: 

Sample Programs and Handouts