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

Questions

Why is it important to build in and review SAS reports about ETL after an ETL protocol is run?
We used a SAS query tool for the BRFSS data and found it to be very limiting in terms of interactivity and data display. What is the source of these limitations?
Imagine you ran a data warehouse where you had to connect to 15 different SQL databases and import data into SAS on a regular basis. How could the SAS Enterprise Guide help you?
Imagine you were advising a SAS data warehouse that had not implemented the SAS Enterprise Guide or SAS Viya, but they want to implement one of them now. Which would be the most appropriate?
Imagine you work at a SAS data warehouse that is very extensive and has been around for decades. Each year, they have upgraded their SAS software, and now have the most current visualization tools. Why might you nevertheless choose to visualize some of the SAS data in non-SAS software?
Imagine a SAS data warehouse comes to you asking...