Kirk Lafler's PROC SQL: Beyond the Basics Using SAS, Second Edition, offers a step-by-step example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book can be approached in a number of ways. Users can read it cover-to-cover or selectively by chapter; they can use the extensive index to find content of interest or refer to the helpful "Summary" that precede each chapter to look for help on a specific topic.

The second edition explores new and powerful features in SAS 9.3, and includes such topics as adding data to a table with a SET clause; bulk loading data from Microsoft Excel; distinguishing between DATA step merges and PROC SQL joins; rules for designing indexes; cardinality and index selectivity; and demystifying join algorithms. It also features an expanded discussion of CASE expressions, and new sections on complex query applications, and grouping and performance. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basic Using SAS, Second Edition, examines a broad range of topics and provides greater detail about this powerful database language using discussion and numerous real-world examples.

About the Author

Kirk Paul Lafler, consultant and founder of Software Intelligence Corporation, has been a SAS user since 1979. He received his BS and MS degrees from the University of Miami. As a SAS Certified Professional, Lafler provides IT consulting services and training to SAS users around the world. He is the author of several other books, including PROC SQL: Beyond the Basics Using SAS (2004), Power AOL: A Survival Guide of Tips and Power SAS: A Survival Guide of Tips, as well as more than 500 papers and articles, and he is the recipient of nearly two dozen "best" contributed paper, hands-on workshop (HOW), and poster awards. Lafler is a frequent speaker at international, regional, special-interest, local, and in-house SAS Users Group conferences and meetings, and he is an emeritus Advisory Board member of sasCommunity.org. He also writes the popular SAS tips column, "Kirk's Korner," that appears regularly in several SAS Users Group newsletters.

"About this title" may belong to another edition of this title.

Store Description

BooksRun helps to save money on textbooks. We are committed to providing each customer with the highest standard of customer service. Please pay close attention to the description of the book and its condition you are ordering. If you have any questions or issues, please make sure to contact us first so we could resolve them. All orders are shipped on the same or the next business day. It usually takes 1 to 5 business days to receive your item if you choose expedited shipping. All orders submitted are eligible for a return within 30 days after the delivery. Thanks for shopping with us!

Visit Seller's Storefront