Why does -merge- not work for you? I would think:
. use <<dataset2>>
. sort N1 N2 N3
. save, replace
. use <<dataset1>>
. sort N1 N2 N3
. merge N1 N2 N3 using <<dataset2>> , nokeep
. generate check=(_merge==3)
(The last line simply creates the check variable, based on whether or
not there was a successful merge.)
Nick WInter
-----------------------------------------------------------
Nicholas Winter, Ph.D. P 202.939.5343
Policy Studies Associates F 202.939.5732
1718 Connecticut Avenue, NW [email protected]
Washington, DC 20009-1148 www.policystudies.com
-----------------------------------------------------------
-----Original Message-----
From: Reka Sundaram-Stukel [mailto:[email protected]]
Sent: Tuesday, April 08, 2003 10:11 AM
To: [email protected]
Subject: st: matching data
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/
*
* 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/
