st: matching data

[Reka Sundaram-Stukel <rsundara@wisc.edu>]

Dear Statalist,

I am interested in matching names in two datasets. For example,

each household head has:

N1			N2			N3
First name 	Second name 	Middle name

I need to create a variable that does the following

gen check=0

if 'N1' in 'data set A' == 'N1' in 'dataset B'
and if  'N2' in 'data set A' == 'N2' in 'dataset B'
and if 'N3' in 'data set A' == 'N3' in 'dataset B'

replace gen check=1

I have tried merge by matching but I don't think that works. I think 
what I need is a command like VLOOKUP (excel) in stata.

any suggestions?



Reka Sundaram-Stukel
Agriculture And Applied Economics
320 Taylor Hall

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/