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 PROC TABULATE for?
How does the ODS allow the programmer to access tables generated during the running of a PROC?
What code needs to be included in order for PROC SGPLOT to use the ODS?
The leader of a department wants the SAS report developer to create a quarterly sales report that includes nicely formatted tables. The department leader wants to write paragraphs below the tables in order to interpret them, and then regard this as the department's official quarterly sales report. What is the most useful format in which to provide these tables to the department leader?
An SAS programmer receives an SAS dataset with about 200 variables. The programmer wants to output the list of variable names to an SAS dataset so that the variable names can be queried. How might the programmer approach this problem using the ODS?
What are the differences between making a histogram in PROC UNIVARIATE, making one in PROC SGPLOT, and making one using PROC...