I need to create one variable containing all 0/1 responses (and its version without blanks) which could be used in further analysis, tabulations etc. What is required is Pct.ofCases which is usually higher than 100%. Multiresponse sets are very common in market research as every question when you select more than one response is treated as multiresponse set. Some of these questions contain more than 30 variables so it's important to find a way in R which is relatively simple in SPSS or other stats tools.
One of examples of required tables is this SPSS table prepared in a couple of minutes:
I think I did not clearly highlight what the main point is though.
In this small sample I have only five 0/1 variables but in many cases I have sets of 20+ variables which are part of multiresponse questions.
I need to find a way of creating a separate variable containing all of these 0/1 questions or data frames which could be easily exported to excel tables but without typing names of all of questions 20+ (5 in this sample file).
I couldn't find any responses about possible packages therefore my idea was creating data frames using range of variables.
Finally, I thought my "categories" and "no.blank.categories" are really basic so I was looking for clever solutions create them using some range statements (like [2:6]) to get counts and Pct.of.Cases.