Status:Closed    Asked:Jun 30, 2014 - 12:17 PM

How do I narrow down the variable INCRETIR to the county level?


I'm trying to measure access to retirement either through pensions, savings for retirement, 401K plans, DB/DC plans, etc. I was wondering if the INCRETIR variable would be a good variable to gauge this. If not, what other variable could I use? After finding the appropriate variable, I need to narrow down my data to the county I live in (Ventura County, CA). If anyone has any information on this, I'd be very appreciative. Thank you.

Do you have the same question? Follow this Question

Staff Answer




INCRETIR will only identify those individuals who reported received retirement, survivor, and disability pension income, other than Social Security in the past 12 months (for ACS). This is not a perfect measure of who has access to retirement, especially if you are wanting to include people who were not currently retired. I don't believe there are any variables that directly measure access to retirement funds.

Ventura County, CA can be identified in the by STATEFIP==6 (California) and COUNTY==1110 (Ventura County). Currently, the COUNTY variable in the 1-year 2012 ACS file in IPUMS-USA does not identify Ventura County, however the PUMAs 11101-11106 (when STATEFIP==6) do identify Ventura County in 2012. With the next update to the IPUMS-USA website Ventura County will be identified for the 1-year 2012 ACS. I hope this helps.


Jul 02, 2014 - 02:59 PM

Report it


Change in CPS EMPSTAT (A-LFSR Labor force status recode) in 2001?
I have an extract 2001 to 2015. Total number of people: 4 million, but in bir...
Why are there fewer counties in the 1950 1% sample compared to the 1940 1% sa...
Is the value of INCWKCOM included in the value of INCDISAB?
Trying to access CPS online analysis tool
ACS METRO variable construction
Login   |   Register

Recently Active Members

View More »

Share |