Hands-On SAS for Data Analysis

Merging

Here, we will look at an instance of one-to-one merging and explore the other merges later in this chapter. First, we will run the following code to change our dataset to ensure we have two different columns, but can still leverage the data we have used for illustration purposes:

Data X  (Rename=(Index=IndexA));Set A;Run;

Now, we will run the Merge code:

Data Merge_XB;Merge X B;Run;

This will give us the following resultant output:

When compared to concatenation and interleaving, the key syntax difference is that you use the Merge statement. In terms of the output, the key difference from the preceding techniques we witnessed is that ...