# Deflating family income

**URL:** <https://forum.ipums.org/t/deflating-family-income/5040>\
**Category:** TIME USE\
**Created:** [January 4, 2023, 4:35pm UTC](https://forum.ipums.org/t/deflating-family-income/5040 "2023-01-04T16:35:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zakir\_Husain](https://avatars.discourse-cdn.com/v4/letter/z/3e96dc/32.png) [@Zakir\_Husain](https://forum.ipums.org/u/Zakir_Husain)\
**Post date:** [January 4, 2023, 4:35pm UTC](https://forum.ipums.org/t/deflating-family-income/5040/1 "2023-01-04T16:35:20Z")

</div>

The family income data in ATUS is in nominal terms. So, if we merge several rounds of ATUS data should we deflate the family income value using Consumer Price index?  
Since family income data is given in categories (ie ranges) how to deflate?

---

<div class="post-metadata">

**Author:** ![Ivan\_Strahof](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/ivan_strahof/32/626_2.png) [@Ivan\_Strahof](https://forum.ipums.org/u/Ivan_Strahof)\
**Post date:** [January 13, 2023, 9:29pm UTC](https://forum.ipums.org/t/deflating-family-income/5040/2 "2023-01-13T21:29:21Z")

</div>

You are correct that it’s necessary to adjust incomes to a given base year. You can find the adjustment factors [on this page](https://cps.ipums.org/cps/cpi99.shtml). Adjusting categorical income however is tricky and is up to the researcher’s discretion. One method is to assign a single value to the interval, such as the midpoint, and adjust all observations within this range for inflation using that value. I also recommend taking a look at what methods others have employed in the literature; a google search provides [a different suggestion here](https://www.socialexplorer.com/help/faq/general/how-are-categorical-values-adjusted-for-inflation).

Alternatively, you may be able to derive the exact family income by [linking respondents to their final CPS interview](https://www.atusdata.org/atus/cpslink.shtml) where they responded to a set of [outgoing rotation group questions](https://cps.ipums.org/cps-action/variables/group/org_org) including [EARNWEEK](https://cps.ipums.org/cps-action/variables/EARNWEEK#codes_section) and [WKSWORKORG](https://cps.ipums.org/cps-action/variables/WKSWORKORG#description_section). I’m happy to provide more information on how to go about linking respondents and reconstructing family income if that’s something you’re interested in.

---

<div class="post-metadata">

**Author:** ![Zakir\_Husain](https://avatars.discourse-cdn.com/v4/letter/z/3e96dc/32.png) [@Zakir\_Husain](https://forum.ipums.org/u/Zakir_Husain)\
**Post date:** [February 2, 2023, 9:48am UTC](https://forum.ipums.org/t/deflating-family-income/5040/3 "2023-02-02T09:48:46Z")

</div>

Dear Ivan

Thank you very much for your informative email.

I had used CPSID to get actual family income and then deflated it using the annual deflators. So that’s done with for the time being !  
However, I do plan to work with ATUS data. So your email and the other methods that you suggest will be useful. If you do not mind, I will get in touch with you again when I resume work on this area later this summer.  
Best regards

Zakir