Just Enough SAS®: A Quick-Start Guide to SAS® for Engineers

Chapter 4. Data Out, Data In—Relational Databases

• 4.1 Introduction 78

• 4.2 Using PROC SQL with SAS Data Sets 79

• 4.3 Using SAS with a Database Management System 84

• 4.4 More Than Enough 94

• 4.5 Chapter Summary 96

Introduction

Statistical data analysis often requires working with data stored in a relational database management system (DBMS). A DBMS is a lot like a SAS library, but with different terms for the various elements.

SAS	DBMS
Library	Database
Data Set	Table
Observation or Row	Record
Variable or Column	Field

Display 4-1 shows the three data sets that are used for the examples in this chapter. One could diagram a simple DBMS using exactly the same picture.

Figure 4-1. The ...