Hi, I am a SAS beginner. I have some data that I need to tabulate: frequency, N and percent tabulations, by another variable (location). The data is from a multiple-choice survey question - there are 20 different multiple choice options, and respondents can choose up to 3 options. I'd like to be able to tabulate the frequency of each option for Location A, Location B, Location C, etc. and calculate the percentage, with the N being the number of people who responded to that question. So I wouldn't want to tabulate rows where none of the option choices have been selected. --> (Can I accomplish this by creating a new variable that concatenates variables of all 20 variables, and then exclude rows with 20 0s?) Location_1 Popn_1 Popn_2 Popn_3 Popn_4..... CityA 1 0 0 0 CityB 0 0 0 0 CityC 0 0 0 0 CityB 0 0 0 0 CityB 0 1 0 0 CityC 0 0 0 0 CityD 0 1 0 0 CityE 0 0 0 0 CityF 0 0 0 0 CityE 1 0 0 0 CityD 1 0 0 0 CityC 1 0 0 0 ........ I was trying to understand this https://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473759.htm, and also https://communities.sas.com/t5/SAS-Programming/Analyzing-Multiple-Response-Variables/td-p/485261 I ran into the same problem as above, was trying this test code: proc tabulate data=cath.testdata2; class location_1; var popn_1-popn_3; table popn_1='Everyone' popn_2='Child' popn_3='Youth', (n='Count' pctn='Percent'); title 'Frequency and Counts for Population Choices'; run; I know that my data has: 141 records where no option is selected; 496 records in total. Output was: Frequency and Counts for Population Choices Count PercentEveryoneChildrenYouth 417 100.00 417 100.00 417 100.00 Additionally I would also like to tabulate, for each location, frequency by each variable against the other. (so the number who have selected popn_1 AND popn_2, etc.) (but after solving the above) I'd like something that looks like this: Count Percent N=355 1: Checked 1: Checked CityA Everyone 5 2% Children 7 Youth City B Everyone 15 4.23% Children … … Youth … … Thanks any help provided
... View more