Hi Stata Community,

I would like to destring multiple answers in my dataset. The survey allowed respondents to choose more than one answer and I would like to separate each one of the selected answers into the parent category. So for example, referring to the table below, if someone chose computer-related, Architecture and Engineering then I would like to take this response add 1 to computer-related, 1 to Architcture and 1 to Engineering. Double counting is ok.

I have tried to find some solutions here but I am stumped - https://www.stata.com/support/faqs/d...ponses/#concat

Thank you in advance for all your help!

Occupation Freq. Percent
Missing 8 0.79
Administrative Specializations 76 7.55
Administrative Specializations,Educat.. 1 0.1
Architecture, Engineering and Surveying 109 10.82
Architecture, Engineering and Surveyi.. 2 0.2
Architecture, Engineering and Surveyi.. 2 0.2
Architecture, Engineering and Surveyi.. 3 0.3
Architecture, Engineering and Surveyi.. 1 0.1
Computer-related 473 46.97
Computer-related,Administrative Speci.. 8 0.79
Computer-related,Architecture, Engine.. 15 1.49
Computer-related,Architecture, Engine.. 2 0.2
Computer-related,Architecture, Engine.. 1 0.1
Computer-related,Architecture, Engine.. 2 0.2
Computer-related,Education 10 0.99
Computer-related,Education,Health 1 0.1
Computer-related,Health 3 0.3
Computer-related,Others 4 0.4
Education 119 11.82
Education,Health 7 0.7
Health 133 13.21
Others 27 2.68
Total 1,007 100