Dear Statalists!

I’m looking for a way to identify the ownership-path of the final investor.
My dataset describes who owns the different companies and how they are linked together.
In my dataset I have variable comp which is the start of the ownership chain (the company being owned). vat_owner is the id of the owner of the current link. Vat_parent is the id owner of the previous link. It’s through vat_owner and vat_parent you can find the path of each ownership. ownershipoflink is the ownership-percentage the vat_owner has of the current link.

The data is an example of investor 6A’s ownership path in comp 1A and 2A.

clear
input str2(comp vat_owner vat_parent) byte linkofownership double ownershipoflink byte _nbycomp
"1A" "2A" "1A" 1 1 1
"1A" "3A" "2A" 2 .5 2
"1A" "4A" "2A" 2 .5 3
"1A" "5A" "3A" 3 .25 4
"1A" "6A" "4A" 3 1 5
"1A" "6A" "5A" 4 1 6
"2B" "1B" "2B" 1 1 1
"2B" "3B" "1B" 2 .5 2
"2B" "4B" "3B" 3 .25 3
"2B" "5B" "3B" 3 .1 4
"2B" "6A" "5B" 4 1 5
"2B" "7B" "4B" 4 .4 6
"2B" "6A" "7B" 5 1 7
end

As you can see investor 6A’s owns shares of the companies each through two different ownership-paths.
I’m looking for a way to identify the different ownership-paths of the final investor 6A so I can calculate their ownership percentage in the starting firm of the specific ownership path.
Any good advice will be very appreciated.