Status:Closed    Asked:Oct 24, 2016 - 05:03 PM

merging data according to geographic level.

Hi Joe,

Thanks, I got your reply.

Then I think I may adjust my analysis on more aggregate level. I am considering doing analysis based on geographic reagion.Can you provide me some information on how to merge data on geographic reagion? Say, county level, city level, MSA level, or urban area level? My target variable is demographic characteristics of unemployment population and change of income inequalities.

Thanks much!



Do you have the same question? Follow this Question

Staff Answer




How to aggregate information up to a geographic unit is largely dictated by what statistical program you are using, taking into consideration the type of summaries you would want on a variable to variable basis (e.g. mean vs. median vs sum vs counts). However, I would actually recommend checking out the NHGIS project (also housed here at the Minnesota Population Center). NHGIS offers aggregate data for many geographic levels, using Census Bureau published summary tables. This way you can get complete coverage using mostly consistent geographic units, such as counties (the public use microdata does not allow for the identification of all counties due to confidentiality restrictions), and consistent aggregate measurements for modern samples. The NHGIS project is primarily intended to facilitate mapping data, but the CSV-format tables provided can be used independently of any GIS software.

I hope this helps.


Oct 25, 2016 - 01:28 PM

Report it


How best to aggregate data to a state level?
Why are not all the "not in the labour force" categories filled for the EMPST...
Incorporating geographic level data in ACS analysis?
Health Insurance Unit in ACS versus MEPS
Login   |   Register

Recently Active Members

View More »

Share |