# How do I calculate the income of a married couple using IPUMS-USA ACS data? **URL:** \ **Category:** USA\ **Created:** [July 16, 2015, 2:56am UTC](https://forum.ipums.org/t/how-do-i-calculate-the-income-of-a-married-couple-using-ipums-usa-acs-data/960 "2015-07-16T02:56:00Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![ninafebner](https://avatars.discourse-cdn.com/v4/letter/n/9dc877/32.png) [@ninafebner](https://forum.ipums.org/u/ninafebner)\ **Post date:** [July 16, 2015, 2:56am UTC](https://forum.ipums.org/t/how-do-i-calculate-the-income-of-a-married-couple-using-ipums-usa-acs-data/960/1 "2015-07-16T02:56:00Z")
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? ---
**Author:** ![Tim\_Moreland](https://avatars.discourse-cdn.com/v4/letter/t/f1d935/32.png) [@Tim\_Moreland](https://forum.ipums.org/u/Tim_Moreland)\ **Post date:** [July 17, 2015, 8:22pm UTC](https://forum.ipums.org/t/how-do-i-calculate-the-income-of-a-married-couple-using-ipums-usa-acs-data/960/2 "2015-07-17T20:22:00Z")
Using [HHINCOME](https://usa.ipums.org/usa-action/variables/HHINCOME#description_section) or [FTOTINC](https://usa.ipums.org/usa-action/variables/FTOTINC#description_section) will be too inclusive for your purposes. HHINCOME sums the income for all persons in the household, and FTOTINC sums the income for all persons in the [family unit](https://usa.ipums.org/usa-action/variables/FAMUNIT#description_section). You are correct that you will need to instead sum the head of household income with the spouse income. Also, keep in mind that it is possible to create a variable within the IPUMS data extract system that contains the income of a respondent’s spouse by utilizing the [Attach Characteristics](https://usa.ipums.org/usa-action/faq#ques38) option. To do so, you should first select your samples and variables, which must contain [INCTOT](https://usa.ipums.org/usa-action/variables/INCTOT#description_section). Before submitting your extract, you will be given the option to choose “Attach characteristics” on the [extract request screen](https://usa.ipums.org/usa-action/extract_requests/summary). Check the box for “Spouse” on the INCTOT row. This will add a variable to your data extract request called INCTOT\_SP. Now simply submit your extract. You should then add up inctot and inctot\_sp for one spouse member. Hope this helps. ---
**Author:** ![Greg\_Oliven](https://avatars.discourse-cdn.com/v4/letter/g/3be4f8/32.png) [@Greg\_Oliven](https://forum.ipums.org/u/Greg_Oliven)\ **Post date:** [July 17, 2019, 2:39pm UTC](https://forum.ipums.org/t/how-do-i-calculate-the-income-of-a-married-couple-using-ipums-usa-acs-data/960/3 "2019-07-17T14:39:23Z")
> [@Tim\_Moreland](#): > > INCTOT\_SP In calculating the average total income for the head of household I use HHWT and PERNUM=1 with INCTOT. Can I simply add INCTOT\_SP, with PERNUM=1 still applied - i.e. are the spouse numbers relative to PERNUM 1? ---
**Author:** ![JeffBloem](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/jeffbloem/32/40_2.png) [@JeffBloem](https://forum.ipums.org/u/JeffBloem)\ **Post date:** [July 17, 2019, 6:50pm UTC](https://forum.ipums.org/t/how-do-i-calculate-the-income-of-a-married-couple-using-ipums-usa-acs-data/960/4 "2019-07-17T18:50:39Z")
If you intend to calculate the total income of spouses and household heads, your approach is correct. Note that this approach will be excluding some couples from your analysis, because by restricting your analysis to only individuals with PERNUM==1 (e.g. household heads) you are restricting your calculations to only including at most one couple per household. In reality, some households could have couples of which neither of whom are the household head. This may not be a big concern to you since you seem to be interested in the average income of the household head and their spouse.