Michael
If you only want the income variable from the B
dataset, you need to create a temporary C dataset
which is a subset of the B dataset
use B
keep city income
save as C
You then sort this new C dataset on city, sort the A
datset on city and follow Michael Blasnik's
suggestion. You then save this new merged dataset as
some variant of A. You can then delete the C datset if
you wish.(I only mention this because I tend not to do
this and have messy little data sub-sets littering my
data folders.)
I did not elaborate on this, but it is only a simple commandline option
with mmerge.ado. In the example I posted earlier today the command was:
