I have a dataset that includes an open-ended response that was coded into categories by a vendor. The vendor created 50 multi-punch categories stored as 50 true/false variables.
By putting this in a multiple response set and cross-tabbing it with itself I can see that most responses seem to be in a small number of categories - the crosstab is strongly diagonal.
For the purposes of an analysis I would like to perform, the categories can only be single-punch. Short of sending this back to the vendor and having them re-categorize over 6,000 responses, I'd like to solve this programmatically if the number of affected responses is small enough. I'd like to write a syntax file that can count the number of respondents categorized into each number of categories - say, 5000 assigned to one category, 1000 assigned to two categories, 500 assigned to three, and so on... If the number assigned to multiple categories is small enough, I'd like to just throw out the ones that were assigned to multiple categories.
Is there an effective way to do this in SPSS syntax? Writing the logic for each possible pair / triplet / quadruplet of multi-response data would be impossible given that I have 50 categories. Any ideas?