Hello everyone,

I am trying to create a proxy that captures whether a loan is considered syndicated or not. What I mean by that is that I want to check whether there is always a specific group of lenders that fund loans.
My data looks like the following:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long LoanId float BiddingTime long LenderId
1 1.6025712e+12 13
1  1.602576e+12 12
1  1.602579e+12  3
1 1.6025852e+12 12
2 1.6025126e+12 18
2  1.602576e+12 12
2  1.602644e+12 46
2  1.602645e+12 45
2 1.6026527e+12 50
2 1.6027344e+12 22
3  1.602577e+12  3
3 1.6025774e+12 12
3  1.602644e+12 13
3 1.6026447e+12 13
end
format %tc BiddingTime
If you can notice from the data, LoanId 1 has lenders 13, 12, and 3 funding it with lender 12 bidding twice on it. The same thing applies to LoanId 3 where the same lenders are funding it but with lender 13 bidding twice. Please note that these are not the only ones that always work together in order to fund a loan. I have many different groups of lenders that work together as well. Is there a way to create a dummy variable that equals 1 if the same group of lenders is funding this loan and is repeated in other loans? Therefore, in my case, loan 1 and loan 3 will equal 1 as the same group of lenders is repeated.

Thank you for your time and I hope that this was clear.