Section 2: Using SAS for Extract-Transform-Load (ETL) Protocols in a Data Warehouse

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:

• Chapter 6, Standardizing Coding Using SAS Arrays

• Chapter 7, Designing and Developing ETL Code in SAS

• Chapter 8, Using Macros to Automate ETL in SAS

• Chapter 9, Debugging and Troubleshooting in SAS