O'Reilly logo

PROC SQL: Beyond the Basics Using SAS, Second Edition by Kirk Paul Lafler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required