Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: matching data


From   Reka Sundaram-Stukel <rsundara@wisc.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: matching data
Date   Tue, 8 Apr 2003 09:49:22 -0500

Nick

Thank you.

The problem is with the order of the data. N1 in <<dataset 1>> equals N3 in <<dataset2>>.

Reka


On Tuesday, April 8, 2003, at 09:14 AM, Nick Winter wrote:


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     nwinter@policystudies.com
 Washington, DC 20009-1148           www.policystudies.com
-----------------------------------------------------------

-----Original Message-----
From: Reka Sundaram-Stukel [mailto:rsundara@wisc.edu]
Sent: Tuesday, April 08, 2003 10:11 AM
To: statalist@hsphsun2.harvard.edu
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/

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index