Status:Closed    Asked:Feb 01, 2018 - 03:09 PM

ACS: Working age adults in family and household

I'm using ACS 2006-2015. I'm currently using the family size variable, but want to create a variable of of how many adults of working age are in the family. Likewise, I want to create a variables of how many adults of working age are in the household.

Do you have the same question? Follow this Question

Staff Answer

The actual mechanics of how you can accomplish this will vary depending on the statistical package you are using. However, if, for example, you are using Stata, a variable that counts the number working adults per household could be created with the following syntax:

egen var=total(age>=15 & age<=64), by(serial)

Similarly, you could do this for the number of working adults per family using FAMUNIT and SERIAL as your "by" variables.

In doing this, there are some things you might want to consider. How are you defining your working population? How would you like to treat the different types of housing units? I would suggest looking at the variable GQ.


Feb 02, 2018 - 10:52 AM

Report it


Hi, it has been over 4 hours for my data extract and I was wondering if there...
When I take several Nov Supplements, the weighted number of voters equals pub...
Are there aggregate categories for OCC/OCCLY in CPS?
Do you have any idea when STEPMOM and STEPDAD will be available for usage? Th...
Comparing 2015 ASEC CPS IPUMS with Census data and Table Creator, I note diff...
I notice a large number of 'missing' or 'N/A' values for education (HIGRADE...
Login   |   Register

Recently Active Members

View More »

Share |