September 2019
Beginner to intermediate
346 pages
7h 35m
English
In the one-to-many merge illustration, we had multiple observations for the same BY group in dataset C. In a many-to-many merge situation, we can end up with multiple observations for the same BY group in different datasets. Let's use the same program we used in the one-to-many merging but with slightly modified datasets:

The merged output is as follows:

The merge was performed successfully as per the LOG. However, the output is incorrect in many ways. The following are a few lines of the LOG:
NOTE: MERGE statement has ...