Creating a new matrix on social network

[Yuko Nakano]

Dear all

I have row data on social networks like

person ID neighbor ID Did you know him? (yes =1)
1 1 0
1 2 1
1 3 0
2 1 1
2 2 0
2 3 1
3 1 0
3 2 1
3 3 0

I would like to know STATA commend to make this data into a 3 by 3 matrix like

1 2 3

1 0 1 0
2 1 0 1
3 0 2 0

Can anybody give me some advice on this?
Please also refer to excel sheet attached.
Thank you very much.

Yuko

[Maarten Buis]

There is a whole suite of social network commands here:

https://nwcommands.wordpress.com/

Before you start reinventing the wheel, take a look at that.

As to your question: the best way really depends on what exactly you want to do with the result. For example, if you just want to look at the adjacency matrix, then I would do nothing to the data, but instead use tabdisp. If you want to do computations, then you have to decide if you want your matrix as a Stata dataset, Stata matrix, or Mata matrix.

[Yuko Nakano]

Dear Maarten

Thank you very much!
In fact, I was trying to use nwcommands and got stuck because I could not understand
how to make my data suitable for using the commands.
I will try tabdisp also.