Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: FW: Getting all combinations of co-occuring IDs
From
Daniel Stefan Hain <[email protected]>
To
"[email protected]" <[email protected]>
Subject
st: FW: Getting all combinations of co-occuring IDs
Date
Fri, 29 Nov 2013 11:49:31 +0000
Dear Statalist members,
I currently deal with a problem I am not sure how to solve it. My case:
I have a dataset with investments of venture capitalists in companies. Since many deals are syndicated, it often appears that multiple investors invest in a company in the same deal. For every investor, I have a single row, so that the data looks somewhat like:
Deal ID Investor ID
1 2
1 7
1 15
1 20
2 9
2 13
3 1
It represents quasi an edgelist. What I need now is a dataset that contains every appearing investor combination in one deal, so that the data would look like:
Deal ID Investor1 ID investor2 ID
1 2 7
1 2 15
1 2 20
1 7 2
1 7 15
1 7 20
1 20 2
1 20 7
1 20 15
2 9 13
2 13 9
3 1 .
Unfortunately, I have no clue how to manage that in stata, and couldn't find any help in the documentation and online forums yet. Every hint is highly appreciated.
Thanks and best wishes
Daniel S. Hain
Ph.D. Fellow, M.Sc. Economics, Dipl.-Wirt.-Ing.
Department of Business and Management | IKE | DRUID | EIS
T: (+45) 9940 2724 | Email: [email protected]
Web: www.ike.aau.dk | www.eis-all.dk | www.innoresource.org Aalborg University | Fibigerstræde 11, Room 91 | DK-9220 Aalborg, Denmark
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/