O'Reilly logo

PROC SQL: Beyond the Basics Using SAS, Second Edition by Kirk Paul Lafler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required