Chapter 9: Debugging and Troubleshooting in SAS

This chapter will provide guidance for debugging and troubleshooting code in SAS. Because much of the code in a data warehouse focuses on extract, transfer, and load (ETL) protocols, we will focus on debugging and troubleshooting data step code. First, we will discuss general strategies for developing, maintaining, and managing data step code and practice troubleshooting when something goes wrong. Next, we will examine ways of debugging the do loop code using SAS debug functions. Finally, we will cover how to prevent errors in SAS macros, and ways to troubleshoot if errors are identified.

We will go over the following practical approaches:

  • Considering the placement of the RUN command in data step ...

Get Mastering SAS Programming for Data Warehousing 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.