PROC SQL: Beyond the Basics Using SAS, Second Edition

Chapter 5: Creating, Populating, and Deleting Tables

Introduction

Creating Tables

Creating a Table Using Column-Definition Lists

Creating a Table Using the LIKE Clause

Deriving a Table and Data from an Existing Table

Populating Tables

Adding Data to a Table with a SET Clause

Adding Data to All of the Columns in a Row

Adding Data to Some of the Columns in a Row

Adding Data with a SELECT Query

Bulk Loading Data from Microsoft Excel

Integrity Constraints

Defining Integrity Constraints

Types of Integrity Constraints

Preventing Null Values with a NOT NULL Constraint

Enforcing Unique Values with a UNIQUE Constraint

Validating Column Values with a CHECK Constraint

Referential Integrity Constraints

Establishing a Primary Key

Establishing a Foreign Key ...