Question

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?




Thanks!!!!!

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Jeff Bloem

Staff

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

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

How can I generate MSA-level data with consistent MSA boundaries in 1990, 200...
How best to aggregate data to a state level?
Using IPUMS ACS multi-year data with aggregate ACS estimates
Why are not all the "not in the labour force" categories filled for the EMPST...
Aggregating data: Can IPUMS data be aggregated to the MSA level? Will these b...
Login   |   Register


Share |