topic Re: Counting Alliance partner unique diadic relationships in SAS Procedures

Counting Alliance partner unique diadic relationships

buckeyefisher — Fri, 02 Sep 2016 14:29:37 GMT

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,

Shmuel — Sun, 04 Sep 2016 09:43:57 GMT

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.

buckeyefisher — Tue, 06 Sep 2016 21:53:26 GMT

Shumel,

Although I am yet to verify all possible combinations, initial results are promising.

Thanks,