You're reading from Mastering SAS Programming for Data Warehousing An advanced programming guide to designing and managing Data Warehouses using SAS

Product type Paperback

Published in Oct 2020

Publisher Packt

ISBN-13 9781789532371

Length 494 pages

Edition 1st Edition

Tools

SAS

Concepts

Application Development

Author (1):

Monika Wahi

Preface

1. Section 1: Managing Data in a SAS Data Warehouse

2. Chapter 1: Using SAS in a Data Mart, Data Lake, or Data Warehouse FREE CHAPTER

3. Chapter 2: Reading Big Data into SAS

4. Chapter 3: Helpful PROCs for Managing Data

5. Chapter 4: Managing ETL in SAS

6. Chapter 5: Managing Data Reporting in SAS

7. Section 2: Using SAS for Extract-Transform-Load (ETL) Protocols in a Data Warehouse

8. Chapter 6: Standardizing Coding Using SAS Arrays

9. Chapter 7: Designing and Developing ETL Code in SAS

10. Chapter 8: Using Macros to Automate ETL in SAS

11. Chapter 9: Debugging and Troubleshooting in SAS

12. Section 3: Using SAS When Serving Warehouse Data to Users

13. Chapter 10: Considering the User Needs of SAS Data Warehouses

14. Chapter 11: Connecting the SAS Data Warehouse to Other Systems

15. Chapter 12: Using the ODS for Visualization in SAS

16. Assessments

17. Other Books You May Enjoy

Chapter 9

Even though code runs the same way no matter how it is formatted, the answer to this question could be false if you are working in a team producing ETL code. In that case, making well-formed and well-formatted code could matter a lot, in that it could save hours of troubleshooting and debugging. However, if you are working on a one-person, one-time project (such as a homework assignment), then the answer to this question could be true.
A good place to start troubleshooting an error in a transformation step is to start by going to the first error registered in the log file and ensuring that semi-colons are in the right place. A next step could be to break the data step apart and see if you can get a smaller piece of it to run.
The programmer uses a PUT statement to ask SAS to print certain values to the log file. A programmer can use the PUT statement during a data step to print certain values to the log file to help with data step troubleshooting.
If you...