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

Chapter 3

The PROC CONTENTS option for this is VARNUM.
These are criteria for when using SAS operators, meaning greater than or equal to 10, and less than or equal to 20.
A programmer may want to attach a user-defined format to a categorical variable with five levels coded 1, 2, 3, 4, and 5 in order to decode each level. That way, if the variable is used in processing, its levels do not display as a code but instead display as a text string, describing what the code means.
The main reason could be that the data is being displayed in an application other than SAS, and therefore, that application could not use SAS labels and formats. However, even in a SAS warehouse, another reason could be that the overhead in maintaining labels and formats is higher than maintaining such metadata another way, so the leaders have chosen to use alternatives.
The programmer can choose whichever way they want to view data. If they have SAS experience, they may choose PROC PRINT, but...