PROC SQL: Beyond the Basics Using SAS, Second Edition

Chapter 7: Coding Complex Queries

Introduction

Introducing Complex Queries

Joins

Why Joins Are Important

Information Retrieval Based on Relationships

DATA Step Merges versus PROC SQL Joins

Types of Complex Queries

Demystifying Join Algorithms

Influencing Joins with a Little Magic

Cartesian Product Joins

Inner Joins

Equijoins

Non-Equijoins

Reflexive or Self Joins

Using Table Aliases in Joins

Performing Computations in Joins

Joins with Three Tables

Joins with More Than Three Tables

Outer Joins

Left Outer Joins

Right Outer Joins

Full Outer Joins

Subqueries

Alternate Approaches to Subqueries

Passing a Single Value with a Subquery

Passing More Than One Row with a Subquery

Comparing a Set of Values

Correlated Subqueries

Set Operations

Rules for Set ...