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

True or false: Because data step code formatting doesn't impact how the program runs, it doesn't matter how the programmer formats data step code files.
Imagine you develop a transformation step, but when you run it, you see many errors. What are the initial troubleshooting steps you can take?
How can using a PUT statement in a data step help a programmer troubleshoot code?
You realize you need to design 10 transformation steps for a new source dataset. How might you approach this task to minimize data step troubleshooting?
What does BREAK do if set on a loop command in the data step debugger?
Imagine you need to make a macro involving two loops and four macro variables, and you are in a hurry. Is it a good idea to skip using the step-by-step process, and just try to make the macro code from scratch since you are in a hurry?
Imagine you decide to slow down and use a step-by-step process to build the macro that involves two loops and...