case
when ethnicity_code = 'H' then 'hisp'
when race_code = 'W' then 'white'
when race_code = 'B' then 'black'
when race_code = 'I' then 'aian'
when (race_code = 'A' or race_code = 'N') then 'api'
else 'unk'
end as re