I’m looking to combine some HUD data, which appears to be identifiable at the county level, with ACS data for 2000-2011. I’m currently having some issues where there appear to be a number of counties without any representation in the ACS data; for example, Miami-Dade county has no observations for county FIPS at all. I think that this is because people living in Miami and other cities would normally be identified by a place code instead, but this isn’t available from IPUMS. The data I’m trying to merge with also has some MSAs, but I realize these can be unreliable when there are large numbers of observations outside the MSA, and the ACS has MetArea instead of MSA.
From what I have been able to find online, my options appear to be:
- Try combining MSA with MetArea codes (not sure if I can do this)
- Attempt to aggregate to PUMA level from county (not sure if this would be successful)
- Try assigning people a county based on their MetArea (probably unreliable)
Am I likely to be more successful in trying to aggregate to Met2013 for the MSA codes, or would something like PUMA make more sense?