PROC SQL: Beyond the Basics Using SAS, Third Edition

Description

PROC SQL: Beyond the Basics Using SAS(R), Third Edition, is 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 not only covers all the basics, but it also offers extensive guidance on complex topics such as set operators and correlated subqueries. Programmers at all levels will appreciate Kirk Lafler's easy-to-follow examples, clear explanations, and handy tips to extend their knowledge of PROC SQL. This third edition explores new and powerful features in SAS(R) 9.4, including topics such as: IFC and IFN functions nearest neighbor processing the HAVING clause indexes It also features two completely new chapters on fuzzy matching and data-driven programming. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basics Using SAS(R), Third Edition, explores this powerful database language using discussion and numerous real-world examples. Contents About This Book What Does This Book Cover? Is This Book for You? What Should You Know about the Examples? We Want to Hear from You Acknowledgments Chapter 1: Designing Database Tables Introduction Database Design Column Names and Reserved Words Data Integrity Database Tables Used in This Book Table Contents Summary Chapter 2: Working with Data in PROC SQL Introduction The SELECT Statement and Clauses Overview of Data Types SQL Operators, Functions, and Keywords Dictionary Tables Summary Chapter 3: Formatting Output Introduction Formatting Output Formatting Output with the Output Delivery System Summary Chapter 4: Coding PROC SQL Logic Introduction Conditional Logic CASE Expressions Interfacing PROC SQL with the Macro Language Summary Chapter 5: Creating, Populating, and Deleting Tables Introduction Creating Tables Integrity Constraints Deleting Rows in a Table Summary Chapter 6: Modifying and Updating Tables and Indexes Introduction Modifying Tables Indexes Updating Data in a Table Summary Chapter 7: Coding Complex Queries Introduction Introducing Complex Queries Joins Why Joins Are Important Cartesian Product Joins Inner Joins Outer Joins Subqueries Set Operations Data Structure Transformations Chapter 8: Working with Views Introduction Views—Windows to Your Data Views and SAS Procedures Eliminating Redundancy Restricting Data Access—Security Hiding Logic Complexities Nesting Views Updatable Views Deleting Views Summary Chapter 9: Fuzzy Matching Programming Introduction Data Sets Used in Examples 6-Step Fuzzy Matching Process Summary Chapter 10: Data-driven Programming Introduction Programming Paradigms SAS Metadata Sources DICTIONARY Tables Custom-defined Formats Macro Language Summary Chapter 11: Troubleshooting and Debugging Introduction The World of Bugs The Debugging Process Types of Problems Troubleshooting and Debugging Techniques Undocumented PROC SQL Options Summary Chapter 12: Tuning for Performance and Efficiency Introduction Understanding Performance Tuning Sorting and Performance User-Specified Sorting (SORTPGM= System Options) Grouping and Performance Splitting Tables Indexes and Performance Reviewing CONTENTS Output and System Messages Optimizing WHERE Clause Processing with Indexes Summary References