-contract-, -reshape-.
contract ID*
reshape wide _freq , i(ID_Ent~1) j(ID_Ent~2)
qui foreach v of var _freq* {
replace `v' = 0 if mi(`v')
}
Having said that, this structure makes
many manipulations more difficult in
Stata, despite possibly seeming more
natural for your problem.
Nick
[email protected]
Sascha Robert
> 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
>
*
* 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/
