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,
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.