If both your data sets are sorted by your BY variables, MERGE is the most efficient way. What is your expected hit rate on the merge, and so you wish to keep alla observations from both data set in the result? Also I wonder about your data, MERGE on I individual loan amounts sounds a bit....odd. That sounds like measure, not a key variable.
... View more
