--KirkLafler 19:56, 3 September 2008 (EDT)

Kirk's PROC SQL Presentations and HOWs at 2008 Fall Regional Conferences

NESUG 2008 (Pittsburgh).....: A Hands-on Tour Inside the World of PROC SQL (September 15, 2008)

PNWSUG 2008 (Seattle).......: Demystifying PROC SQL Join Algorithms (September 22, 2008)
                              Exploring the Undocumented PROC SQL _METHOD Option (September 23, 2008)

MWSUG 2008 (Indianapolis)...: PROC SQL Programming - The Basics and Beyond (October 14, 2008)
                              SAS Tips, Tricks and Techniques (October 14, 2008)

SESUG 2008 (St. Pete Beach).: Exploring the Undocumented PROC SQL _METHOD Option (October 20, 2008)
                              Undocumented and Hard-to-find PROC SQL Features (October 21, 2008)

SCSUG 2008 (Houston)........: Exploring Dictionary Tables and SASHELP Views (October 27, 2008)
                              Understanding WHERE Clause Processing and Indexes (October 27, 2008)

WUSS 2008 (Universal City)..: Demystifying PROC SQL Join Algorithms (November 2008)
                              Exploring the Undocumented PROC SQL _METHOD Option (November 2008)
                              A Hands-on Tour Inside the World of PROC SQL (November 2008)
                              Building Effective SAS® Indexes (November 2008)

Using the PROC SQL _METHOD Option
by Kirk Paul Lafler, Software Intelligence Corporation

Abstract
The _METHOD option provides valuable information about the execution methods triggered by a PROC SQL query using a sequence of codes. With the results automatically displayed on the SAS Log, the information can be used to better understand a query’s execution as well as enabling performance tuning and debugging operations by SAS users in the know.

Paper: Using the PROC SQL _METHOD Option

--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.

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

Learn, share and have fun with PROC SQL!