PROC SQL: Beyond the Basics Using SAS, Second Edition

Chapter 9: Troubleshooting and Debugging

Introduction

The World of Bugs

The Debugging Process

Types of Problems

Troubleshooting and Debugging Techniques

Validating Queries with the VALIDATE Statement

Documented PROC SQL Options and Statement

Undocumented PROC SQL Options

Macro Variables

Troubleshooting and Debugging Examples

Summary

 

Introduction

When it comes to tracking down the source of SQL coding problems, users can be very resourceful. To find all those pesky errors, warnings, notes, and unexpected results, you need to carefully inspect the SAS log and telltale clues from code reviews and sample runs. Using reliable troubleshooting and debugging techniques will help get to the root of any syntax, data, system related, and logic errors ...