Mastering SAS Programming for Data Warehousing

Table of Contents

Preface

Section 1: Managing Data in a SAS Data Warehouse

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

Technical requirements  4

Using original versions of SAS  4

Initial SAS data handling  5

Early SAS data handling  8

SAS data handling improvements  10

Accessing data in SAS  11

Upgrading to mainframes  11

Transitioning to personal computers  12

Reading external files  13

Improving I/O  17

Developing warehouse environments  17

Using the WHERE clause  18

Using IF compared to WHERE  19

Sorting in SAS  20

Setting indexes on variables  22

Dealing with storage and memory issues  24

Avoiding memory issues  24

Accommodating Structured Query Language  25

Using PROC SQL  26

Using SAS today in a warehouse environment  28 ...