SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition > Chapter 2: Performing Advanced Queries Using PROC SQL > Subsetting Data by Using Correlated Subqueries - Pg. 73: Safari Books Online

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

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

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

Search

Contents

Table of Contents

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

About This Book

PART 1: SQL Processing with SAS

Chapter 1: Performing Queries Using PROC SQL

Chapter 2: Performing Advanced Queries Using PROC SQL

Viewing SELECT Statement Syntax

Displaying All Columns

Limiting the Number of Rows Displayed

Eliminating Duplicate Rows from Output

Subsetting Rows by Using Conditional Operators

Subsetting Rows by Using Calculated Values

Enhancing Query Output

Summarizing and Grouping Data

Subsetting Data by Using Subqueries

Subsetting Data by Using Noncorrelated Subqueries

Subsetting Data by Using Correlated Subqueries

Validating Query Syntax

Additional Features

Chapter 3: Combining Tables Horizontally Using PROC SQL

Chapter 4: Combining Tables Vertically Using PROC SQL

Chapter 5: Creating and Managing Tables Using PROC SQL

Chapter 6: Creating and Managing Indexes Using PROC SQL

Chapter 7: Creating and Managing Views Using PROC SQL

Chapter 8: Managing Processing Using PROC SQL

PART 2: SAS Macro Language

PART 3: Advanced SAS Programming Techniques

PART 4: Optimizing SAS Programs

PART 5: Quiz Answer Keys

URL

Help

Staffmaster.EmpID proc sql; select lastname, firstname from sasuser.staffmaster