[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: RE: corporate integration
> 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.
* For searches and help try: