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

Chapter 8Managing Processing Using PROC SQL

Overview

Introduction

Objectives

Prerequisites

Specifying SQL Options

Controlling Execution

Restricting Row Processing

Example

Controlling Output

Including a Column of Row Numbers

Example

Double-Spacing Output

Example

Flowing Characters within a Column

Example

Testing and Evaluating Performance

Writing Timing Information for Each Statement

Example

Resetting Options

Overview

Example

Using Dictionary Tables

Overview

Exploring and Using Dictionary Tables

Example

Example

Additional Features

Restricting the Number of Loops

Stopping Execution in PROC SQL after an Error

Summary

Contents

Text Summary

Syntax

Sample Programs

Points to Remember

Quiz

Overview

Introduction

The SQL procedure offers a variety of options ...