Status:Closed    Asked:Jun 17, 2014 - 01:48 PM

When I merge the PWPUMA10 with the 2012 1-yr estimates, the calculations are incorrect. Could be the weights?

I used the PWPUMA10 variable provided by staff in a previous question posted here. After merging the file with my existing 2012 1-year file, everything seems to match correctly. However, once I weight the dataset using PERWT, the PWPUMA10 variable doesn't seem to correctly calculate. The estimates appear to be way too high for the geography I am interested in. Any help you could provide is much appreciated.

Do you have the same question? Follow this Question

Staff Answer




There are a number of potential causes for overly large PWPUMA populations. First, make sure to use the variable PWSTATE2, as PWPUMAs are state dependent. Also make sure you are calling on the correct PWPUMAs, as PWPUMA codes differ from PUMA codes. PWPUMA codes and boundaries can also differ by year. the 2012 ACS was the first year to use new geographies based on the 2010 Decennial Census so the PWPUMA codes and boundaries in the 2012 ACS are different from those used in the 2000-2011 samples. The Census Bureau provides a crosswalk between PWPUMAs (called POWPUMAs in the Census Bureau documentation) and PUMAs in the 2012 1-year code list.

I hope this helps.


Jun 18, 2014 - 11:09 AM

Report it


Matching 2012 ACS 1-year PUMS with 2011 metro variable (since 2012 metro vari...
Why is the place of work PUMA (pwpuma00) variable missing from the 2012 ACS 1...
Will the PWCITY variable be released with the 2012 1-yr estimates?
Why doesn't the 3 yr ACS (2012) have a COUNTY variable when each of the 1% sa...
Login   |   Register

Recently Active Members

View More »

Share |