Status:Closed    Asked:Feb 09, 2017 - 11:32 AM

how to aggregate data to household level

Dear IPUMS staff, I was told that both Metarea and Metfips are not consistent along the year.

So now I am very very confused about which variable to use if I want to aggregate data to MSA level.

Specially, my question is:

I want to look at the distribution of household income in each MSA from 2005-2016.

So I need to aggregate data to a "Year-MSA panel" using CPS ASEC.

Can you give me some suggesstions about which MSA variable can I use to aggregate data?


Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


One imperfect, but perhaps worthwhile method would be to limit your sample to only the metropolitan areas that can be identified in all of the years from 2005 - 2016. You can see which metropolitan areas these are if you follow the procedure described in this answer. This will allow you to aggregate data along the geography variable METAREA, but only for those areas which are identifiable in all years your are analyzing.

I hope this is helpful.


Feb 10, 2017 - 08:18 AM

Report it


How can I generate MSA-level data with consistent MSA boundaries in 1990, 200...
Why are not all the "not in the labour force" categories filled for the EMPST...
Is IPUMS ACS data representative at the MSA level?
Health Insurance Unit in ACS versus MEPS
Login   |   Register

Recently Active Members

View More »

Share |