I'm sorry if this has been asked a thousand times, but I haven't found the answer by searching the forums, or google.
I have 10 variables that use the same value label. I want to create a table like the ones you get with the tab varname command, where you get the number of observations in each variable according to the label values.
For example, I have the label 0 "no level" 1 "level 1" 2 "level 2". And I have the variables A1, A2 and A3. I need a table that looks lik this:
Label name A1 A2 A3
no level 20 10 13
level 1 14 13 16
level 2 12 10 21
The values in the cells are the number of observations.
It seems simple enough, but how can I do this?