I want to count diadic relationship between alliance partners per year.
Data have;
No Principal Firm Partner Firm Year
1 a b 1991
2 b c 1991
3 a x 1992
4 a b 1992
5 x a 1993
6 x z 1994
7 c b 1995
8 b a 1996
Data Want;
No Principal Firm Partner Firm Year Alliance History Count (Cumulative)
1 a b 1991 1
2 b c 1991 1
3 a x 1992 1
4 a b 1992 2
5 x a 1993 2
6 x z 1994 1
7 c b 1995 2
8 b a 1996 3
(Alliance between 'a' - 'b' and between 'b' -'a' should be treated as same)
I tried Proc SQL distinc, but just gives unique relationships. I need count at the diadic relationship level
Thanks,
You can create an intermediate variable sort_key by:
if principal gt partner
then sort_key = partner || principal;
else sort_key = principal || partner;
then run your sql counting group by sort_key.
Shumel,
Although I am yet to verify all possible combinations, initial results are promising.
Thanks,
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.