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

What is the difference between a macro variable and a macro in SAS?
What do the system options NONOTES, NOSTIMER, NOSOURCE, and NOSYNTAXCHECK do?
Why is it necessary to build SAS macros in a step-by-step manner? Why not try to compose the perfect macro code from scratch?
Why are conditions added to macros?
What is the advantage of storing macros in separate files than the SAS files that call them?
Imagine you were working at a data warehouse and were told that you would be assigned to design and conduct ETL on some historic datasets that were being added to the warehouse. What would you need to know in order to decide whether or not to develop a macro to load the files?
Imagine you are an analyst at a SAS data warehouse, and you learn that you are being asked to add a new set of data to the warehouse. The dataset consists of responses of small business owners to a survey done by the local chamber of commerce. The chamber does this survey every...