I am doing a project calculating economic sufficiency based on total income along 6 axis: married couples that own their own homes with a mortgage, married couples that own their own home without a mortgage, singles that own their own home with a mortgage, singles that own their own home without a mortgage, married couples that rent a one bedroom, singles that rent a one bedroom.
I am using ACS data from the years 2009-2013.
I selected for state (CA), county, and age (over 65). I attached a characteristic to age- head of household and also to INCTOT- head of household and spouse.
I created 6 new variables based on the axes above, including in each one that the head of household has to be 65+.
I want to sort by county, tabulating each new variable and summarizing the income in each case.
In stata I use the command for each variable that involves a single person: by county: tab (variable name), summ (inctot_head).
I do I caclulate the right income in each case for the married couples? Should I use HHINCOME, FTOTINC, or run inctot_head and inctot_spouse separately for each variable and add the totals?