Dear Statalists,
for my research on repeated alliances I am using a dataset in which each observation represents one alliance. I want to group observations such that alliances between the same participating companies appear in one group. For this I have two string variables, part_cusip1 and part_cusip2, which each contain the CUSIP Number of Partner 1 and Partner 2 respectively. Unfortunately, there are observations in which the same participants are present, but the relative positions of the CUSIP Numbers is exchanged. When I use egen idgroup=group(part_cusip1 part_cusip2), it ignores those observations and considers them a group in and of itself. Consider following example of how the data looked after I used the command:
obs idgroup part_cusip1 part_cusip2
1 1 000001 000002
2 1 000001 000002
3 2 000002 000001
4 1 000001 000002
5 3 000003 000004
As you can see, while the same participants are involved in observation 3 (000001 & 000002), the command considers it as its own group. Is there any way to circumvent this problem? My dataset has 36000 observations, so checking if each part_cusip1 appears in part_cusip2 and then manually changing idgroup if the same participants are involved would be a lot of work and I would prefer to avoid it.
Thank you for your help!
Related Posts with Forming groups by two string variables that are interchangeable
Constraints and Convergence in GSEM Hello everyone, I´m working for the first time with gsem (have used sem in the past, but never wit…
Distance between latent score and lower cutoff after Ordered Probit?Dear colleagues, I have regressed an ordered ordinal outcome y = {1,2,3,4,5,6,8.9,10} on explanator…
Very Short code ?I'm using Stata 15.1 and I'm trying to replicate an example from the UCLA Statistical consulting sit…
) required r(100) (Hard time changing labels)Hello everyone, I am taking my first course in econometrics and therefore very much an amateur. At…
About file names case sensitivity in Stata for LinuxHi, all. I have found what seems to me at least an asymmetry in the way Stata deals with files with…
Subscribe to:
Post Comments (Atom)
0 Response to Forming groups by two string variables that are interchangeable
Post a Comment