Sascha Robert reported privately that
this did what he wanted.
Nick
[email protected]
Alan Neustadtl
> This looks like a social network problem. How about using Ucinet or
> Pajek? Both are designed for problems like this and then can be used
> for an appropriate graph-type analysis. Ucinet can be used for a
> limited time for free, Pajek is free.
Nick Cox
> > -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.
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/