User:KirkLafler/BlogEntry: 2008 August 15 14:01:46 EDT
From sasCommunity
Undocumented and Hard-to-find PROC SQL Features
by Kirk Paul Lafler, Software Intelligence Corporation
Abstract
The SQL Procedure contains many powerful and elegant language features for experienced SQL users. This paper
introduces topics that will help users unlock many hidden features, options, and other hard-to-find gems in the
SQL universe. Topics include: conditional logic scenarios using case expressions; techniques on implementing table
integrity constraints; an in-depth analysis of indexes and their uses; complex queries with join and set operators;
integrating DICTIONARY tables with the macro language; and performance tuning techniques to improve query
processing.
Paper: Undocumented and Hard-to-find PROC SQL Features
