st: converting data to adjacency matrix

[Sascha Robert <sascha.robert@iew.unizh.ch>]

Hi

I am quite new STATA, no wonder I can't solve the following problem:

I got data that represents relationships between entities:

"ID_Entity_1"        "ID_Entity_2"
1                    2
1                    2
2                    3
3                    1

I want to convert this data into a adjacency matrix looking like this:

                "ID_1"     "ID_2"     "ID_3"
"ID_1"             0          2          0
"ID_2"             0          0          1
"ID_3"             1          0          0

How can I do it?

Best regards,
Sascha

--
***** sascha robert | mailto: sascha.robert@iew.unizh.ch *****
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/