Dear all,

I am stuck at a problem, although the solution should be straightforward.

I have several 5-point Likert-scale item sets (different dimensions of a construct, each measured by a different number of items) and for each set I would like to present a descriptive table with the item name in the first column and the response categories in the columns 2-6. The cells should give the percentage of responses in the respective categories. That means the table should look like this:
completely agree somewhat agree undecided somewhat disagree completely disagree TOTAL
Item 1 10% 20% 10% 50% 10% 100%
Item 2 20% 10% 50% 10% 10% 100%
Item 3 10% 20% 10% 50% 10% 100%
Item 4 5% 20% 40% 30% 5% 100%
Is there an easy way to do that in Stata? I am using Stata 15. (Of course, I am aware that I could use "tab1 item1-item10" and then manually transpose the table in Excel separately for each item but I thought that perhaps there is a more convenient solution for that.)


Best

Peter