September 2019
Beginner to intermediate
346 pages
7h 35m
English
Compared to the one-to-one matching via BY Matching, there is no change in syntax required for one-to-many merging. The difference is in the input and output datasets. The following tables are the datasets that we will merge in one-to-many merging:

We have introduced a third dataset here, C, which contains multiple observations for some cities. It contains the index values of previous years as well. Up until now, we had a separate variable (instead of a row) that contained the previous index values in the various examples in this chapter. We have a one row per city situation in datasets A and B, but a multiple rows per ...
Read now
Unlock full access