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

Chapter 15Combining Data Horizontally

Overview

Introduction

Objectives

Prerequisites

Reviewing Terminology

Overview

Relationships between Input Data Sources

Working with Lookup Values Outside of SAS Data Sets

Overview

The IF-THEN/ELSE Statement

Example: Using the IF-THEN/ELSE Statement to Combine Data

SAS Arrays

Example: Using the ARRAY Statement to Combine Data

User-Defined SAS Formats

Example: Using the FORMAT Procedure to Combine Data

Combining Data with the DATA Step Match-Merge

The DATA Step Match-Merge

Working with Multiple Lookup Tables

Example

Using PROC SQL to Join Data

The SQL Procedure

Example: Working with Multiple Lookup Tables

Comparing DATA Step Match-Merges and PROC SQL Joins

Overview

Examples

DATA Step Match-Merge

Execution of ...