Hands-On SAS for Data Analysis

By Matching

For performing By Matching, we have the following information about the cost of living in two different datasets, A and B, at hand:

We want to join the two datasets together so that we have one wide dataset with 10 rows of observations for City and nine variables.

Let's use the same form of Merge that we used earlier when generating the output for Merging:

Data Cost_Living;Merge A B;Run;

We get the desired output in the following table. The two datasets have been combined based on the order of the observations:

But what if the ...