Calculating combined prevalence of diseases

[Nile Dangeli]

I have a dataset containing diagnoses of 9 different conditions: asthma, angina, arthritis, COPD, cancer, diabetes, HBP, depression and visual impairment. The answers are coded as 0 (has no condition) and 1 (has the condition) which means that combined score ranges from 0 to 9. My calculation shows that 8% of the population had a combination of 4, 13% of 3 and 26% of 2 different conditions. The combination could be be anything like asthma+ angina+ arthritis+ COPD or cancer+HBP. My question is, is there any way to know the exact combination of the different conditions using STATA 14.

More precisely, for those who had 2 conditions, how many had BP+cancer, BP+Asthama, asthma+COPD and so on.

Thanks in advance for sharing your insights!

[Rich Goldstein]

yes, but it is not clear exactly how you want this to work; -egen- has at least two functions that will help, but in different ways; so look at

help egen

and particularly at the (1) concat function and (2) the group function with the label option