And perhaps anything with a comma could/should be treated as "more than one race"?
For one project where I have stuff like this I actually create a series of dichotomous variables such as
rw = index(Race,'White')>0;
rb = index(Race,'Black')>0;
ra = index(Race,'Asian')>0;
/* and for those who think Hispanic is a race*/
rh = index(Race,'Hispanic)>0;
Because I have to report on multiracial, those that are only one race or that report combinations.
sums or max of multiple variables are then easy ways to find the specific examples.
HB = sum(rb,rh)=2; for instance creates a dichotomous variable indicating Black Hispanics. Which is much easier once you get used to it than: IF rb and rh then HB=1; else HB=0;
... View more