I need to separate Asian and Pacific Islander races in the 2013 USA PUMS file. The variable “Race” combines Asian and Pacific Islander. There also appears to be overlap in “Raced” among the Asian, Pacific Islander, and Two or More Races. I tried several iterations and I get a compensating error when I recode one or more of the previously mentioned races.
Is there a crosswalk for how MPC codes its race values for the variables “Race” and “Raced”? Also, why does the two or more races value in “Race” differ from the census PUMS value? They should be the identical.
My SPSS syntax is:
RECODE RACED (100 =1) (120 =1) (130 =1) (200=2)(210=2)(300 thru 399 =5) (400 thru 620 =3) (640 thru 651 =3)(653 thru 679 =3)(630 thru 634 =4) (652= 4) (680 thru 699 =4) (700 = 6) (801 thru 868 =7) (869 =3) (880 thru 886 =7)
(887 =7) (890 thru 892 =7) (893 =4) (889 thru 975 =7) (976 =3) (980 thru 996 =7) (110 =8) (140 =8) (150 =8) (MISSING=SYSMIS) (ELSE=Copy) INTO RACE1.
EXECUTE.
VARIABLE LABELSRACE1 ‘Race Recode’.
VALUE LABELS RACE1
1 ‘White’
2 ‘Black’
3 ‘Asian’
4 ‘Native Hawaiian Pacific Islander’
5 ‘American Indian Alaskan Native’
6 ‘Some Other Race’
7 ‘Two or More Races’
8 ‘Hispanic’
.
I am trying to match these USA & PR PUMS values
|
Total RAC1P
|
319,743,925
|
|
White alone
|
235,566,763
|
|
Black or African American alone
|
40,262,753
|
|
Asian alone
|
16,020,903
|
|
Native Hawaiian and Other Pacific Islander alone
|
512,757
|
|
American Indian and Alaska Native tribes specified; or American Indian or Alaska Native, not specified and no other races
|
2,560,101
|
|
Some other race alone
|
15,159,031
|
|
Two or More Races
|
9,661,617
|