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


Does using the INCLUGH variable over time requires correcting for the VERIFY=...
Does CLASSWKR in ASEC regarding self-employment (code 10) include incorporate...
I am trying to cross age, urban, and race. Which weight am I supposed to use?
Regarding Top-Coded and Replacement Values for 1990 HHINCOME
What happened to the tobacco use questions? They seem to have disappeared.
Do you have a plan to release earlier Contingent worker supplement data (1995...
Login   |   Register

Recently Active Members

View More »

Share |