User:KirkLafler/BlogEntry: 2008 September 07 02:37:55 EDT
From sasCommunity
--KirkLafler 02:40, 7 September 2008 (EDT)
Kirk's Ten Best PROC SQL Tips and Techniques
by Kirk Paul Lafler, Software Intelligence Corporation
Abstract
The SQL Procedure contains many powerful and elegant language features for experienced SQL users. This tutorial
introduces SQL 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: Kirk's Ten Best PROC SQL Tips and Techniques.
