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

st: RE: corporate integration


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: corporate integration
Date   Tue, 26 Aug 2003 13:54:48 +0100

Chao Feng

> I have a Dataset containing corporate structures and want 
> to find out about corporate integration, i.e. I want to 
> mark those observations (i.e. firms) which mutually hold 
> shares in their businesses.
> The structure is as follows (toy example):
> 
> "parent firm"  "subsidiary company" "amount of holding"
> 
> 1234                     5678                         25%
> 1234                     7788                        100%
> 1234                     8897                          70%
> 5678                     1234                          30%
> 5678                     3484                         100%
> 6666                     9099                          60%
> 
> records 1 and 4 (i.e. firms number 1234 and 5678 mutually 
> hold shares and I trying to find a way to identify them 
> with Stata but have not found a solution yet.

gen min = cond(parent < subsidiary, parent, subsidiary) 
gen max = cond(parent >= subsidiary, parent, subsidiary) 
duplicates list min max 

This works for strings as well. 

For canned solutions in this area, see also 
-fndmtch- and -fndmtch2- on SSC. 

Nick 
n.j.cox@durham.ac.uk 




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