Dear statalisters,

I have the following data structure.

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str50 id float(club1 club2 club3 club4 club5 club6)
"ab1"           1 0 0 0 0 0
"ab2"      1 0 0 0 0 0
"ab3"      0 0 1 0 0 0
"ba3"      0 1 0 0 0 0
"ce4"            1 0 0 0 0 0
"kl7"              0 0 0 0 1 0
"gb5"         0 0 0 0 1 0
"tv2"             1 0 0 0 0 0
end
where id is a unique user id for each observation, and club1 ... club6 are dummies wheter the id is member of the club or not. I want to make a 6-way tabulation of the percantage within each club that is also a member of the other clubs. Perhaps the data should be restructured., im not sure. So what i want is something that looks like the following:
club1 club2 club3 club4 club5 club6
club1 -
club2 % of members of club 1 who are also members of club 2 -
club3 etc -
club4 -
club5 -
club6 -
Total nr of members club 1 nr of members club 2 nr of members club 3 nr of members club 4 nr of members club 5 nr of members club 6
Any advice would be very helpful as I now spend alot of time manually plotting it from two-way tabulations. (Bonus: If anybody has a solution that can be automatically exported to a MS word format, that would be amazing.)

Thanks,

Maximilan