SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition > Chapter 3: Combining Tables Horizontally Using PROC SQL > Understanding Joins - Pg. 87: 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

Chapter 3: Combining Tables Horizontally Using PROC SQL

Understanding Joins

Generating a Cartesian Product

Using Inner Joins

Using Outer Joins

Creating an Inner Join with Outer Join-Style Syntax

Comparing SQL Joins and DATA Step Match-Merges

Using In-Line Views

Joining Multiple Tables and Views

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