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

Chapter 3Combining Tables Horizontally Using PROC SQL

Overview

Introduction

Objectives

Prerequisites

Understanding Joins

Generating a Cartesian Product

Using Inner Joins

Introducing Inner Join Syntax

Example

Understanding How Joins Are Processed

Eliminating Duplicate Columns

Renaming a Column by Using a Column Alias

Joining Tables That Have Rows with Matching Values

Specifying a Table Alias

Example: Complex PROC SQL Inner Join

Example: PROC SQL Inner Join with Summary Functions

Using Outer Joins

Introducing Types of Outer Joins

Using a Left Outer Join

Using a Right Outer Join

Using a Full Outer Join

Example: Outer Join

Creating an Inner Join with Outer Join-Style Syntax

Comparing SQL Joins and DATA Step Match-Merges

Overview

When All of the Values ...