So the issue is that we need to double count (or triple count) some of these respondents because they could have said multiple “other” companies. Your syntax is giving us the % that said “other” in any of the 3 possible mentions (I just verified this by computing a variable that does this in SPSS and my % matches what Report Builder says) and we need the total that said “other” across the 3 mentions. I thought we could fix this by coding the “other” mentions different in each variable (i.e., 26 if they said it in 1st mention, 27 if they said it in 2nd mention), but that didn’t seem to do the trick either.
Leave a Reply