Hands-On SAS for Data Analysis

Concatenating

We will use data similar to the Cost of Living dataset that we used in Chapter 1, Introduction to SAS Programming.

The following are the two datasets:

Use the following code to concatenate the two tables:

Data Concatenate_AB;        Set A B;Run;

This will give us the following output:

While concatenating, we try to stack observations of different datasets. There are complexities around the length of the observations, the different number of variables in datasets, and missing values that alter the resolution of concatenation. We will ...