SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition

Chapter 7Creating and Managing Views Using PROC SQL

Overview

Introduction

Objectives

Prerequisites

Creating and Using PROC SQL Views

PROC SQL Views

Creating PROC SQL Views

Example

Using PROC SQL Views

Displaying the Definition for a PROC SQL View

Overview

Example

Managing PROC SQL Views

Guidelines for Using PROC SQL Views

Omitting the Libref

Using an Embedded LIBNAME Statement

Example

Creating a View to Enhance Table Security

Example

Updating PROC SQL Views

Overview

Example

Dropping PROC SQL Views

Overview

Example

Summary

Contents

Text Summary

Syntax

Sample Programs

Points to Remember

Quiz

Overview

Introduction

A PROC SQL view is a stored query expression that reads data values from its underlying files, which can include SAS data files, DATA ...