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 good to include _list at the end of an array name?
What does adding a condition to an array accomplish?
Why is it often necessary to rename variables for arrays?
What considerations do SAS data warehouse managers need to make about serving up index variables to users?
Why would an organization such as the MCHP publish their SAS code and array programming information for certain indexes they maintain in their datasets for the public to see?
Imagine you have a dataset with 250 responses to 20 survey questions, and the variables are all coded as 1, 2, 3, 4, or 5, indicating a spectrum of strongly disagree = 1 to strongly agree = 5. You learn that this is a weekly customer satisfaction survey. You will be receiving hundreds of surveys in this structure every week, and you need to load them and make a report every week. Your supervisor wants you to create flags for each question on each survey, where the answers are coded as either 4 = somewhat...