This week's SAS tip is from Kirk Lafler and his book PROC SQL: Beyond the Basics Using SAS. A SAS user since 1979, Kirk often takes his expertise on the road and is a frequent speaker at SAS conferences. He's also currently working on a second edition of the book.
If you're interested in PROC SQL, visit Kirk's author page for bonus content including a free chapter, samples and tips, user reviews, and more information about his upcoming book. Also, view his previously featured tips on this blog: Creating custom SAS functions with the FCMP Procedure and Displaying integrity constraints.
The following excerpt is from SAS Press author Kirk Lafler and his book "PROC SQL: Beyond the Basics Using SAS." Copyright © 2004, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. (please note that results may vary depending on your version of SAS software)