hi,
I have two sets of data: data about control relationships between firms (firm, parent firm, ultimate parent firm) and alliances between firms. I need a way to figure out who is at the top of the control pyramid using the first set of data, and then, in the alliance data, replace all firms lower down on the control pyramid with the firm at the top of the control pyramid.
1) For instance, my data about control relations between firms is shown below. I need a way to automatically figure out that A2 is at the top of this control pyramid.
firm, parent, ultimate parent
A, A1, A2
A1, A1, A1
A3, A4, A
2) My data about alliances between firms is shown below:
Participant 1, Participant2
A, B
A3, C
A1, D
3) I need to incorporate the data about control relationships (A2 is at the top of the control pyramid involving A, A1 A3, A4) in the data about alliances so that my alliance file looks like this:
A2, B
A2, C
A2, D
I will be very grateful for any ideas you can suggest to do the above.
thanks so much
dalhia
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
