PROC SQL: Beyond the Basics Using SAS, Second Edition

Chapter 8: Working with Views

Introduction

Views—Windows to Your Data

What Views Aren’t

Types of Views

Creating Views

Displaying a View’s Contents

Describing View Definitions

Creating and Using Views in SAS

Views and SAS Procedures

Views and DATA Steps

Eliminating Redundancy

Restricting Data Access—Security

Hiding Logic Complexities

Nesting Views

Updatable Views

Inserting New Rows of Data

Updating Existing Rows of Data

Deleting Rows of Data

Deleting Views

Summary

 

Introduction

In previous chapters, the examples assumed that each table had a physical existence, that is, the data stored in each table occupied storage space. In this chapter, let’s turn our attention to a different type of table structure that has no real physical existence. This ...