Concatenation

When we were introduced to concatenation, we looked at the simplest of datasets. Both datasets had variables with similar attributes, equal variable length, and the same type of variables. We ended up with a result that had the two datasets stacked together.

Different variable length and additional variables

Now, we will look at some small dataset differences that we need to overcome in the practical world. As part of the deep dive, we will also look at the APPEND methodology to concatenate datasets. Let's get started:

Data Customer;
Set Customer_X Customer_Y;
Run;

This will give us the following tables as output:

Note that we have missing values for the Dependents variable in the output:

A quick look at...