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 12

It is important to build SAS reports into the ETL process that report metrics about the ETL and can help us troubleshoot if anything goes wrong during the ETL protocol. In one of the examples in this chapter, we said if we knew that the state of Alaska only has 10 hospitals, and California has over 300, then we would never expect to see Alaska as the state with the most staffed hospital beds throughout the whole of the US. Therefore, if we had a SAS report among our ETL reports that selected the state with the most staffed beds after one data load, and that happened to be Alaska, it would alert us to look more closely at what happened during ETL, because Alaska would be an illogical result.
The source of the limitations we saw in the SAS implementation that provides a query tool for the BRFSS is that SAS has added features over the years to allow data to be displayed over the web. In other words, these features are add-ons to SAS. Because they are add-ons, these...