Chapter 11: Troubleshooting and Debugging

Introduction. 365

The World of Bugs. 365

The Debugging Process. 366

Types of Problems. 367

Troubleshooting and Debugging Techniques. 368

Validating Queries with the VALIDATE Statement 368

Documented PROC SQL Options and Statement 369

Undocumented PROC SQL Options. 382

Macro Variables. 383

Troubleshooting and Debugging Examples. 385

Summary. 389

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

Get PROC SQL, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.