Good morning everyone, I describe my problem and the solution I need. I have a table with pairs that identify relationships between two people (for example, friends in a social network). My end result should be a table in which each record defines a group in which all people are related, directly or through other people. For example, starting from the following image My input table looks like this: data have;
input member1 member2;
datalines;
1 2
1 4
2 3
2 4
3 8
4 5
4 6
5 7
5 8
6 7
7 8
9 10
9 11
9 12
10 12
11 12
; And my output table should be the following: Initially I don't know the maximum number of people in a relationship (but I don't think it will exceed 20 in this problem) Has anyone faced a similar problem? Can you think of any way to solve it? Thanks for your time, Merry Christmas and Happy 2021!!
... View more