Chapter 7: Designing and Developing ETL Code in SAS
This chapter demonstrates how to design and develop extract, transform, and load (ETL) code in SAS. The SAS data warehouse serves users, and the main services it provides has to do with presenting data in a manner that is easy to understand, analyze, and visualize. Therefore, successful SAS data warehouses will have ETL protocols that are organized, transparent, and evidence-based, because these practices lead to providing valid, accurate, and easy-to-use data to users.
This chapter will cover these main topics:
How to conduct preliminary research on categorical and continuous variables to inform the development of ETL code
How to split up the tasks of planning coding from the actual coding, ...
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.
