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

Chapter 23Selecting Efficient Sorting Strategies

Overview

Introduction

Objectives

Prerequisites

Avoiding Unnecessary Sorts

Overview

Using BY-Group Processing with an Index

Comparative Example: Using BY-Group Processing with an Index to Avoid a Sort

Using the NOTSORTED Option

Example

Using FIRST, and LAST

Example

Using the GROUPFORMAT Option

Example

Using the CLASS Statement

Example

Comparative Example: Using a BY or CLASS Statement to Avoid a Sort

Using the SORTEDBY= Data Set Option

Example

Using a Threaded Sort

Overview

Using the CPUCOUNT= System Option

Calculating and Allocating Sort Resources

Sort Space Requirements

Example

Using the SORTSIZE= Option

Handling Large Data Sets

Dividing a Large Data Set

Comparative Example: Dividing and Sorting ...