# 2 variable table with birthplace and migration

**URL:** <https://forum.ipums.org/t/2-variable-table-with-birthplace-and-migration/3380>\
**Category:** USA\
**Created:** [February 25, 2020, 11:21pm UTC](https://forum.ipums.org/t/2-variable-table-with-birthplace-and-migration/3380 "2020-02-25T23:21:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adam\_Cohen](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@Adam\_Cohen](https://forum.ipums.org/u/Adam_Cohen)\
**Post date:** [February 25, 2020, 11:21pm UTC](https://forum.ipums.org/t/2-variable-table-with-birthplace-and-migration/3380/1 "2020-02-25T23:21:49Z")

</div>

Hello forum,

I’m trying to generate a table that shows state of birth along the rows and state of residence along the columns (I’m primarily interested in where people current live given they were born in Hawaii, and would like to compare # of people who stay/leave to other states). When I select “2018 ACS” from [IPUMS USA](https://usa.ipums.org/usa/sda/) and enter “bpl” for Row and “migplac1” for column, I get an error message:  
"Warning: a table is not displayed because the total number of cells would have exceeded the maximum allowed (=8000). Row variable = bpl Column variable = migplac1 "

When I I run the same table but filter with bpl(015), over 86% of the cases are coded as state = 0 (N/A).

Appreciate any help you offer.

Best,  
Adam  
[https://adamcohen3.github.io/](https://adamcohen3.github.io/)

---

<div class="post-metadata">

**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:** [February 26, 2020, 5:43pm UTC](https://forum.ipums.org/t/2-variable-table-with-birthplace-and-migration/3380/2 "2020-02-26T17:43:08Z")

</div>

As long as I understand what you are trying to calculate correctly, you should be using [STATEFIP](https://usa.ipums.org/usa-action/variables/STATEFIP#description_section) and not [MIGPLAC1](https://usa.ipums.org/usa-action/variables/MIGPLAC1#codes_section) as your column variable. STATEFIP identifies an individual’s current state of residence. MIGPLAC1, on the other hand, identifies the state of residence _1 year ago_ for _those who lived in a different house 1 year ago_. Therefore anyone who lives in the same house as they did one year ago will be recorded as MIGPLAC1==0 “N/A.” I just tried this in SDA and was able to generate a table similar to what you seem to be describing here.

---

<div class="post-metadata">

**Author:** ![Adam\_Cohen](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@Adam\_Cohen](https://forum.ipums.org/u/Adam_Cohen)\
**Post date:** [February 27, 2020, 12:21am UTC](https://forum.ipums.org/t/2-variable-table-with-birthplace-and-migration/3380/3 "2020-02-27T00:21:23Z")

</div>

Jeff, thank you. You’re correct - I needed STATEFIP. Everything looks good now.

Appreciate your help!  
Adam
