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: [email protected]
Web: www.warwick.ac.uk/staff/P.Martins
*****************************************************
>>> [email protected] 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/