Section 1: Managing Data in a SAS Data Warehouse

This first section focuses on the basics of managing data in a data warehouse in SAS. First, we focus heavily on the process of data input/output (I/O) in SAS, which has not changed since SAS was originally created. Then, we see how to use data steps and PROCs, or SAS procedures, to read big data into SAS in various formats, given SAS's distinct data I/O processes.

After that, we are introduced to PROCs in SAS that can help manage data, especially with respect to I/O. These include PROCs that allow you to view and profile the dataset, including PROC CONTENTS and PROC PRINT.

Then, we see how to prepare for extract, transform, and load (ETL) processes by setting naming conventions, designating user groups, and setting other policies. Lastly, we are introduced to SAS's output delivery system (ODS) and see how reporting is done in SAS.

This section comprises the following chapters:

• Chapter 1, Using SAS in a Data Mart, Data Lake, or Data Warehouse

• Chapter 2, Reading Big Data into SAS

• Chapter 3, Helpful PROCs for Managing Data

• Chapter 4, Managing ETL in SAS

• Chapter 5, Managing Data Reporting in SAS