Hi all,

I have 150 forums and proportion of participants who said they were interested in 7 different issue areas (see below). I would like to make a forum by forum similarity matrix based on the following formula. With this formula not saved in Stata (like Euclidean distance), how would I go about proceeding? It seems impossible to calculate these all by hand. Thanks so much.


[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input float forumid double(q4_waterprov q4_watqua q4_bio q4_islan q4_flood q4_clim q4_other)
102 0 1 1 1 1 0 0
103 1 1 1 1 1 1 0
104 1 1 1 0 0 0 0
106 1 .7777777777777778 .2777777777777778 .2222222222222222 .16666666666666666 .2222222222222222 .1111111111111111
107 .5 .5 0 0 0 .5 .5
109 0 0 1 0 1 0 0
110 1 1 1 1 1 0 0


Array