-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
Mastering SAS Programming for Data Warehousing
By :
This section explains how to develop and optimize extract, transform, and load (ETL) protocols in a SAS data warehouse. First, we cover using SAS arrays, and why array processing is a necessary component of a SAS ETL protocol. Next, we go through a process of first designing an ETL protocol, and then developing SAS code to execute the protocol. Then, we describe automating ETL code using the SAS macro language, and show how to convert data step code into macros. And finally, we discuss various approaches used in SAS for debugging and troubleshooting, with a specific focus on debugging do loops and macros.
This section comprises the following chapters: