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

Re: st: Merging two datasets and finding the closest match


From   "Pedro Martins" <P.Martins@warwick.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Merging two datasets and finding the closest match
Date   Mon, 04 Nov 2002 22:22:49 +0000

one way that may work, provided you don't have too many observations, would be 
joinby year industry using the_other_data_set
and then keeping the matches whose assets are not "too" different
pedro martins


****************************************************
Pedro Martins
Department of Economics
University of Warwick
Coventry CV4 7AL
United Kingdom

Tel: +44/0 24765 28418
Fax: +44/0 24765 23032
Email: p.martins@warwick.ac.uk
Web: www.warwick.ac.uk/staff/P.Martins
*****************************************************
>>> Christine_Tan@baruch.cuny.edu 04/11/02 18:42 >>>
Dear Statalisters:

I wish to merge two datasets based on three variables: (1) Year (2)
Industry and (3) Total assets.  The first two variables have to be
identicial but the third does not have to be.  In other words, I have a
list of firms whereby I would like to find another firm that, in the same
year and industry has the closest total assets.

Thank you.

Chris Tan



*
*   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/



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