Hi,
I would greatly appreciate if you can send me files with program. I
think that this sort of problem is rather general, especially recently
when many people try to combine data from different sources. So, it
would be nice to include it in Stata.
My email is [email protected]
Thanks,
Oleksandr.
>>> [email protected] 09/18/03 12:03PM >>>
Michael,
From: "Michael Blasnik" <[email protected]>
To: <[email protected]>
Subject: st: Re: Re: RE: matching in Stata
Date sent: Thu, 18 Sep 2003 11:54:04 -0400
Send reply to: [email protected]
> I have written an ado (nearmrg.ado) that I think directly addresses
this
> problem. It allows specifying a list of variables that must match
exactly
> between the datasets (gender and region in your dataset?) and
requires you
> to specify one variable that is matched to the "closest" value in the
using
> file. The closest value may be defined in a few ways, including some
ways
> that allows the use of string variables. I can email the files to
you
> directly if you are interested. I may post it to SSC if there is
general
> interest.
I'd like to put in a vote for an SSC posting - I've had occasion in
the past to do this kind of merge, and I know colleagues who have
faced similar problems and who would find this program helpful. We'd
all be deeply indebted if you did....
--Mark
>
> Michael Blasnik
> [email protected]
>
> ----- Original Message -----
> From: "Oleksandr Shepotylo" <[email protected]>
> To: <[email protected]>
> Sent: Wednesday, September 17, 2003 12:21 PM
> Subject: st: Re: RE: matching in Stata
>
>
> > 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.
> >
> > ----- Original Message -----
> > From: "Chih-Mao Hsieh" <[email protected]>
> > To: <[email protected]>
> > Sent: Wednesday, September 17, 2003 11:56 AM
> > Subject: st: RE: matching in Stata
> >
> > > Dear Oleksandr
> > >
> > > I would imagine that -merge- is what you're looking for, maybe
with a
> > couple -gen- commands along the way. What is ultimately done will
depend
> on
> > what you intend to do with all the "extra" observations in X2
(whether you
> > still want to match those, or you have a rule to leave some
unmatched).
> > >
> > > Chihmao.
> > >
> > > -----Original Message-----
> > > From: [email protected] on behalf of
Oleksandr
> > Shepotylo
> > > Sent: Wed 9/17/2003 10:01 AM
> > > To: [email protected]
> > > Cc:
> > > Subject: st: matching in Stata
> > >
> > > Dear Statalist,
> > >
> > > Is there any Stata procedure that will match observations from
2
> different
> > > datasets drawn from the same population.
> > > Let's say, I have datasets X1=(x,y) and X2=(x). I want to
construct
> > > X2*=(x*,y) based on mathching observations with closest x's.
Also, since
> > X2 has more observations correspondence should not be 1 to 1.
> > >
> > > Thanks,
> > >
> > > Oleksandr.
>
>
>
> *
> * 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/
Prof. Mark E. Schaffer
Director
Centre for Economic Reform and Transformation
Department of Economics
School of Management & Languages
Heriot-Watt University, Edinburgh EH14 4AS UK
44-131-451-3494 direct
44-131-451-3008 fax
44-131-451-3485 CERT administrator
http://www.som.hw.ac.uk/cert
*
* 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/
