PROC SQL: Beyond the Basics Using SAS®

Chapter 8. Working with Views

8.1	Introduction 258
8.2	Views — Windows to Your Data 258
	8.2.1 What Views Aren’t 259
	8.2.2 Types of Views 260
	8.2.3 Creating Views 262
	8.2.4 Displaying a View’s Contents 263
	8.2.5 Describing View Definitions 264
	8.2.6 Creating and Using Views in the SAS System 265
	8.2.7 Views and SAS Procedures 266
	8.2.8 Views and DATA Steps 269
8.3	Eliminating Redundancy 270
8.4	Restricting Data Access—Security 270
8.5	Hiding Logic Complexities 272
8.6	Nesting Views 274
8.7	Updatable Views 277
	8.7.1 Inserting New Rows of Data 278
	8.7.2 Updating Existing Rows of Data 283
	8.7.3 Deleting Rows of Data 286
8.8	Deleting Views 287
8.9	Summary 288