# Extracting variables from IPUMS CPS

**URL:** <https://forum.ipums.org/t/extracting-variables-from-ipums-cps/5484>\
**Category:** General\
**Created:** [October 11, 2023, 9:43pm UTC](https://forum.ipums.org/t/extracting-variables-from-ipums-cps/5484 "2023-10-11T21:43:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vedika\_Nair](https://avatars.discourse-cdn.com/v4/letter/v/9de053/32.png) [@Vedika\_Nair](https://forum.ipums.org/u/Vedika_Nair)\
**Post date:** [October 11, 2023, 9:43pm UTC](https://forum.ipums.org/t/extracting-variables-from-ipums-cps/5484/1 "2023-10-11T21:43:03Z")

</div>

When extracting variables from the IPUMS-CPS website, can I extract household and person variables in the same extract or do I need to create two different extracts and then merge?

---

<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:** [October 12, 2023, 3:57pm UTC](https://forum.ipums.org/t/extracting-variables-from-ipums-cps/5484/2 "2023-10-12T15:57:38Z")

</div>

Yes, all variables that are added to your data cart are included in a single extract regardless of whether they are household or person-level variables. In this regard, IPUMS allows users to select whether they want their data provided in a hierarchical data file or be rectangular on the person-level. The former provides separate household and person-level records within the extract each with their own variables, while the latter merges data from household records to person records within the household and does not retain the households as separate records. These format options are available in the _extract request_ page once you’ve added samples and variables to your data cart, viewed your cart, and selected to create your extract. Simply click on Change under the _Structure_ heading and select between these options (see screenshots).

 ![Extract Request](https://us1.discourse-cdn.com/flex019/uploads/ipums/original/1X/0286881d74c5bac313e0834b662ba97f3aee73b4.png)  
 ![Data format](https://us1.discourse-cdn.com/flex019/uploads/ipums/original/1X/9d90f3bc807ebf614a9e8a1849b1bb558098a297.png)
