Sorry, I wasn't precise enough :/
I don't want to know how many people answered "yes" for a certain question but how many questions a certain person answered with yes.
It's a question about environmental activities in companies - I want to have a new variable, which indicates the number of "green" activities in each company.
RIght now the variables are coded like this:
[Question: Is the measure xx applied in your company?] [xx= 1,...,14]
1 = yes
2 = no
8 = prefer not to say
9 = I don't know
I would like to have a new variable looking like that
[How many measures are applied in this company?]
0 = 0
1 = 1
2 = 3
14 = 14
In this way I could examine later on if there is a connection with amount of measures and other variables.
Maybe you already gave me the right answer and I wasn't able to aggregate correct. But I ended up with the total numbers of "yes", not separated by samples. Thank you for the help!