Chapter 4: Managing ETL in SAS
This chapter covers issues and topics that need to be considered and addressed in the management of extract, transform, and load (ETL) functions in a SAS data warehouse. First, we discuss the different storage environments needed within the SAS data warehouse, and how staff user groups must be designated to correspond to these different storage environments so that access to them is internally controlled. Second, managing the storage of documentation for source datasets and recommendations for dataset naming conventions are covered.
Next, we describe SAS arrays, and a demonstration explaining how they are used in data steps (when performing transformation) is provided. The use of arrays can impact variable naming ...
Get Mastering SAS Programming for Data Warehousing now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
