I am trying to collapse als USA PUMS files by ancestry and survey wave. In particular in the 1980s survey, there are a very large number of (subnational) categories, which I would like to map back to the country of ancestry; i.e.
should become Germany etc.
Does any such mapping already exist? Where could I find it?
What would be an alternative to identify the share of foreigners/ancestry by state by survey wave or year?
Thanks in advance for your time!