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

Chapter 2Performing Advanced Queries Using PROC SQL

Overview

Introduction

Objectives

Prerequisites

Viewing SELECT Statement Syntax

Displaying All Columns

Using SELECT *

Using the FEEDBACK Option

Limiting the Number of Rows Displayed

Overview

Example

Eliminating Duplicate Rows from Output

Example

Subsetting Rows by Using Conditional Operators

Overview

Using Operators in PROC SQL

Using the BETWEEN-AND Operator to Select within a Range of Values

Using the CONTAINS or Question Mark (?) Operator to Select a String

Example

Using the IN Operator to Select Values from a List

Using the IS MISSING or IS NULL Operator to Select Missing Values

Example

Using the LIKE Operator to Select a Pattern

Specifying a Pattern

Example

Using the Sounds-Like (=*) Operator ...