Status:Closed    Asked:Apr 20, 2017 - 12:58 PM

Preselect MULTYEAR when selecting PUMA for multi-year ACS?

I guess this is a feature request?

Seems like preselecting MULTYEAR when selecting a PUMA for a multi-year ACS sample is a good idea. Otherwise the PUMA is really difficult to interpret. For example, for a 5-year ACS sample spanning 2010-2014, the 2010 and 2011 observations use the 2000 PUMA convention and the 2012, 2013, and 2014 observations use the 2010 PUMA convention. Without the manually selecting the MULTYEAR variable, you cannot determine which PUMA geography to use.

The workaround I've used - without creating a new extract, downloading, unzipping, etc - is to match the 2010 PUMAs to the entire dataset, then match the 2000 PUMAs that aren't in the 2010 PUMAs to the remainder of the dataset.

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


Yes, this is an unfortunate artifact of how the multiyear ACS files are generated. It is a perpetual issue that many users of ACS multiyear files encounter. Your suggestion is a good one and we will pass it along to the IT team. Perhaps MULTYEAR could be automatically preselected when a multiyear sample has been selected.


Apr 21, 2017 - 10:17 AM

Report it


Thanks Jeff -- much appreciated!


Apr 21, 2017 - 10:27 AM

Report it


How can I accurately calculate the median family income by state for families...
Detailed Variables Dropping From Dataset
Are weights adjusted when using "select cases" in an extraction?
Is there more information on the jobs in the IND variable from the WORK secti...
Occupation label in original language
Can you determine the states people move from to a certain state?
Login   |   Register

Share |