PROC SQL, 3rd Edition

Chapter 5: Creating, Populating, and Deleting Tables

Introduction. 153

Creating Tables. 154

Creating a Table Using Column-Definition Lists. 154

Creating a Table Using the LIKE Clause. 158

Deriving a Table and Data from an Existing Table. 159

Populating Tables. 160

Adding Data to a Table with a SET Clause. 161

Adding Data to All of the Columns in a Row.. 164

Adding Data to Some of the Columns in a Row.. 169

Adding Data with a SELECT Query. 171

Bulk Loading Data from Microsoft Excel 172

Integrity Constraints. 177

Defining Integrity Constraints. 178

Types of Integrity Constraints. 178

Preventing Null Values with a NOT NULL Constraint 178

Enforcing Unique Values with a UNIQUE Constraint 181

Validating Column Values with a CHECK Constraint 182