14
Lafler, Kirk Paul (2006), “A Hands-on Tour Inside the World of PROC SQL,” Proceedings of the 31
st
Annual SAS
Users Group International Conference, Software Intelligence Corporation, Spring Valley, CA, USA.
Lafler, Kirk Paul (2005), “Manipulating Data with PROC SQL,” Proceedings of the 30
th
Annual SAS Users Group
International Conference, Software Intelligence Corporation, Spring Valley, CA, USA.
Lafler, Kirk Paul (2004). PROC SQL: Beyond the Basics Using SAS, SAS Institute Inc., Cary, NC, USA.
Lafler, Kirk Paul (2003), “Undocumented and Hard-to-find PROC SQL Features,” Proceedings of the Eleventh Annual
Western Users of SAS Software Conference.
Lafler, Kirk Paul, PROC SQL Programming for Beginners; Software Intelligence Corporation, Spring Valley, CA, USA;
1992-2007.
Lafler, Kirk Paul, Intermediate PROC SQL Programming; Software Intelligence Corporation, Spring Valley, CA, USA;
1998-2007.
Lafler, Kirk Paul, Advanced PROC SQL Programming; Software Intelligence Corporation, Spring Valley, CA, USA; 2001-
2007.
Lafler, Kirk Paul, PROC SQL Programming Tips; Software Intelligence Corporation, Spring Valley, CA, USA; 2002-2007.
SAS
®
Guide to the SQL Procedure: Usage and Reference, Version 6, First Edition; SAS Institute, Cary, NC, USA; 1990.
SAS
®
SQL Procedure User’s Guide, Version 8; SAS Institute Inc., Cary, NC, USA; 2000.
Acknowledgments
I would like to thank Melodi Muehlbauer, Foundations and Fundamentals (Beginning Tutorials) Section Chair, for
accepting my abstract and paper. I’d also like to thank Dr. LeRoy Bessler, Alix Riley, and Craig Wildeman for a
terrific conference.
Trademark Citations
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS
Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product names are
trademarks of their respective companies.
About the Author
Kirk Paul Lafler is consultant and founder of Software Intelligence Corporation and has been using SAS since 1979.
Kirk provides IT consulting services and training to SAS users around the world. As a SAS Certified Professional, Kirk
has written four books including PROC SQL: Beyond the Basics Using SAS, and more than four hundred peer-
reviewed papers and articles. He has also been an Invited speaker and trainer at more than three hundred SAS
International, regional, local, and special-interest user group conferences and meetings throughout North America.
His popular SAS Tips column, “Kirk’s Korner of Quick and Simple Tips”, appears regularly in several SAS User Group
newsletters and Web sites, and his fun-filled SASword Puzzles is featured in SAScommunity.org.
Comments and suggestions can be sent to:
Kirk Paul Lafler
Software Intelligence Corporation
World Headquarters
P.O. Box 1390
Spring Valley, California 91979-1390