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
[email protected]
*
* 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/
