PROC SQL: Beyond the Basics Using SAS®

Chapter 5. Creating, Populating, and Deleting Tables

5.1	Introduction 138
5.2	Creating Tables 138
	5.2.1 Creating a Table Using Column-Definition Lists 139
	5.2.2 Creating a Table Using the LIKE Clause 143
	5.2.3 Deriving a Table and Data from an Existing Table 145
5.3	Populating Tables 147
	5.3.1 Adding Data to All the Columns in a Row 148
	5.3.2 Adding Data to Some of the Columns in a Row 151
	5.3.3 Adding Data with a SELECT Query 155
5.4	Integrity Constraints 156
	5.4.1 Defining Integrity Constraints 156
	5.4.2 Types of Integrity Constraints 156
	5.4.3 Preventing Null Values with a NOT NULL Constraint 157
	5.4.4 Enforcing Unique Values with a UNIQUE Constraint 160
	5.4.5 Validating Column Values with a CHECK Constraint 162
	5.4.6 Referential Integrity Constraints ...