An Introduction to SAS University Edition

Chapter 14: Subsetting and Combining SAS Data Sets

Introduction

Subsetting (Filtering) Data in a SAS Data Set

Describing a WHERE= Data Set Option

Describing a Subsetting IF Statement

A More Efficient Way to Subset Data When Reading Raw Data

Creating Several Data Subsets in One DATA Step

Combining SAS Data Sets (Combining Rows)

Adding a Few Observations to a Large Data Set (PROC APPEND)

Interleaving Data Sets

Merging Two Data Sets (Adding Columns)

Controlling Which Observations Are Included in a Merge (IN= Data Set Option)

Performing a One-to-Many or Many-to-One Merge

Merging Two Data Sets with Different BY Variable Names

Merging Two Data Sets with One Character and One Numeric BY Variable

Updating a Master File from a Transaction File (UPDATE ...