SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition

Overview

Introduction

In SAS programming, a common task is to combine observations from two or more data sets into a new data set. Using the DATA step, you can combine data sets in several ways, including the following:

Method of Merging (Combining)	Illustration
One-to-one merging Creates observations that contain all of the variables from each contributing data set. Combines observations based on their relative position in each data set. Statement: SET
Concatenating Appends the observations from one data set to another. Statement: SET
Appending Appending adds the observations in the second data set directly to the ...