Announcing an opportunity to attend a training session prior to our next quarterly meeting on July 14, 2009:
PROC SQL Programming: The Basics and Beyond
This course expands your PROC SQL programming skills using numerous examples and techniques of this powerful database language. Topics include strategies for creating and using virtual tables known as views, using case expressions to perform conditional logic scenarios and reclassification of data values, complex queries using inner and outer join constructs including set operators, database design concepts including basic normalization rules, examples of implementing table integrity constraints, accessing information contained in read-only dictionary tables, interfacing PROC SQL with the Macro facility to create macro variables and macro variable lists, rules associated with index creation and usage, undocumented and hard-to-find PROC SQL features for debugging and performance purposes, and performance tuning strategies.
Intended Audience: All SAS users
Prerequisites: SAS Basics course or 6-months SAS software experience
Delivery Method: Instructor-led with code examples
Length: 3-Hours, (8:30am - 11:30am)
Cost: $99.00 per attendee
Location: U.S. Bank, Riverbank Center, 2751 Shepard Road, St. Paul, MN 55116
To register for the training please contact Kirk directly at KirkLafler@cs.com
Bio for Kirk Paul Lafler, Software Intelligence Corporation
Kirk Paul Lafler is consultant and founder of Software Intelligence Corporation and has been programming in SAS since 1979. As a SAS Certified Professional, Kirk provides IT consulting services and training to SAS users around the world. As the author of four books including PROC SQL: Beyond the Basics Using SAS (SAS Institute. 2004), Kirk has written more than three hundred peer-reviewed papers and has been an Invited speaker 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 fun-filled SASword Puzzles are featured in www.SAScommunity.org and several newsletters. Kirk’s current professional interests include social networking/social media research pertaining to professional relationship expansions; database performance tuning; “best” practice SAS coding techniques; and is a member of the sasCommunity.org Advisory Board.
Contact Information
Kirk Paul Lafler
Senior Consultant, Trainer and Author
Software Intelligence Corporation
World Headquarters
P.O. Box 1390
Spring Valley, CA 91979-1390
KirkLafler@cs.com