PROC SQL: Beyond the Basics Using SAS, Third Edition

✍ Scribed by Kirk Paul Lafler

• Publisher: SAS Institute
• Year: 2019
• Tongue: English
• Leaves: 420
• Edition: 3.
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

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