Contents

 

About This Book

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

Populating Tables

Integrity Constraints

Deleting Rows in a Table

Deleting Tables

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

Complex Query Applications

Summary

Chapter 8: Working with Views

Introduction

Views—Windows to Your Data

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

CALL EXECUTE Routine

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