I have 8 racial variables, and participants can choose up to eight. The majority of people choose one or two, but I have 300 people who I've recorded as multiracial, due to clicking more than one option. I did this via making new variables and assigning 1s to the boxes that were checked, making it so that everyone who chose one race ended up with a score of one, and everyone who chose more than one was greater than one. Now that I've identified multiracial participants, I'd like to get the breakdown of single race participants- should I do that via dropping my multiracial participants? If I just run the original racial variables, the system chooses whatever is marked first- so if you marked black, white, and native american, you'd just show up as black. My end goal is to have a statement like: "300 participants chose more than 1 racial identifier and were considered multiracial. Of those 300, X percent identified as 2 races and X percent identified as 3 or more. Of the X participants who chose one racial identifier, X% identified as Black, X% identified as White, etc" Example code: If wh=1, then Nwh=1 If wh=0 then Nwh=0 If bl=2 then Nwbl=1 If bl=0 then Nwbl=0 This is repeated for all racial variables, then I have: If Nwh+NwBl=1 then Prace="single" If Nwh+NwBl>=2 then Prace="multi" (except with all 8 variables going into the statement, not just the 2 example ones)
... View more