Social network data

[juliehn]

Hi,

I need to restructure my data set in order to use it as social network data. In the attached file there is the input data and how I want it to be structured (Solution 1 or Solution 2).

Thank you!

[ballardw]

1) no attached file

2) best to provide existing data in the form of a data step so we have no need to question variable names or types

3) I think you need to describe what is going on in "solution 1". Why is there a 2 A 1 but no 3 C 2 for instance.

Is solution 2 a report or a data set? You cannot have a variable named 1, 2 or 3 in a SAS data set so you would have to show what variables you actually want.

[ChrisHemedinger]

@ballardw and @juliehn - I removed the attachment (XLS) file and replaced with a picture inline -- thought that would be more useful for experts to respond.

[Ksharp · Accepted solution]

Assuming I understood what you mean.

data have;
input point $ person;
cards;
A 1
A 2
B 1
B 2
B 3
C 2
C 3
;
run;
proc sql;
select a.point,a.person as person1,b.person as person2
 from have as a,have as b
  where a.point=b.point and a.person ne b.person
   order by 2,1;
quit;

[juliehn]

It worked and data is organised just like I wanted.Thanks a mil!

[TomKari]

I think you'll find either of your preferred structures will turn out to be impractical in practice, as the number of persons and meeting points expands. Here's a solution I did for someone else, which groups the nodes into networks. From there, you should be able to restructure it as needed.

Tom

data TestData;
	input From To;
	cards;
1 15
1 16
15 16
2 16
2 17
16 17
3 4
4 5
5 6
6 18
7 18
8 19
9 19
10 20
10 19
20 19
11 8
12 21
12 20
12 13
21 20
21 13
20 13
13 22
13 23
22 23
14 23
14 24
23 24
9 25
run;

proc optnet data_links=TestData out_nodes=Networks;
	concomp;
run;