Hello members, I am seeking the most efficient solution or examples to output percentages of response categories in a tabular format for an opinion survey using the answer categories and specifications further below,. Any feedback or code would be greatly appreciated, especially for the the most and least positive answer categories. The metric, Score0-100 is calculated by assigning a higher weight to more positive responses. In this way, the higher the Score0-100, the more positive the result. Across the questions with a five-point response scale, the most positive response is assigned a weight of 100, the second most positive response is given a weight of 75, the third most positive response is given a weight of 50, the second least positive response is assigned a weight of 25 and the least positive response category is given a weight of 0. When Score 0-100 is provided for a group, the average score is calculated across respondents in that group. For example, if there were 20 respondents in a group, the Score0-100 for each person would be summed and divided by 20 to give the average of the Score0-100. SCORE100 is calculated by removing the DK and NA, and then attributing a score of… 100 to the most positive answer category 75 to the second most positive answer category 50 to the neutral category 25 to the second most negative answer category 0 to the most negative answer category
... View more
