Dear Chih-Mao,
-merge is not good because even though two samples are form the same
population they have different observations and can not be matched
perfectly.
My problem can be demostrated with the following example:
Dataset1:
person age gender region income
1 20 M MD 10,000
2 45 F CA 100,000
Dataset 2:
person age gender region income
1 23 F DC ?
2 35 M TX ?
I need program that will match people based on age gender region
and will set income in dataset2 based on closest match from 1.
Oleksandr.
This may be a bit late, but here's another angle on this problem.
