# This regards output using MIGPUMA1 and reading PUMS values - see details below

**URL:** <https://forum.ipums.org/t/this-regards-output-using-migpuma1-and-reading-pums-values-see-details-below/1641>\
**Category:** USA\
**Created:** [March 13, 2017, 5:58pm UTC](https://forum.ipums.org/t/this-regards-output-using-migpuma1-and-reading-pums-values-see-details-below/1641 "2017-03-13T17:58:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dharma1953](https://avatars.discourse-cdn.com/v4/letter/d/977dab/32.png) [@dharma1953](https://forum.ipums.org/u/dharma1953)\
**Post date:** [March 13, 2017, 5:58pm UTC](https://forum.ipums.org/t/this-regards-output-using-migpuma1-and-reading-pums-values-see-details-below/1641/1 "2017-03-13T17:58:00Z")

</div>

to determine the migration flow out of a county (50) by age and where they went I Jeff,

I produced the following table: Row - Age; Column - MIGPUMA1; Control - Statefip; and Filter - Statefip (9) and County (50).

T he table has values like this for the column

| 0 | 1 | 2 | 100 | 190 | 200 | 300 | 390 |

| 400 | 500 | 600 | 700 | 800 | 900 | 990 | 1100 | 1200 | 1300 | 1390 | 1400 | 1500 | 1600 |

|

| 1700 | 1900 | 2000 | 2100 | 2300 | 2400 | 2500 | 2800 | 2900 | 3000 | 3100 | 3200 | 3490 | 3500 | 3600 | 3700 | 3800 |

| | | | | | | | | | | | | |

etc. running up to 7500, 10000, 11300, 11500 and 40100.

How do I determine state? I have the Codes Tab you sent but where on these values is the state identifying variable? Do I need to add an additional variable (to control or filter) to produce the state ID variable to my table?

Help. Thank you. David Carroll

---

<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:** [March 15, 2017, 3:33pm UTC](https://forum.ipums.org/t/this-regards-output-using-migpuma1-and-reading-pums-values-see-details-below/1641/2 "2017-03-15T15:33:00Z")

</div>

If I understand what you are trying to do correctly, this may be challenging to do within the online analysis tool. This is because [MIGPUMA1](https://usa.ipums.org/usa-action/variables/MIGPUMA1#description_section) is state-dependent and can only be interpreted in combination with [MIGPLAC1](https://usa.ipums.org/usa-action/variables/MIGPLAC1#codes_section). I can think of two options going forward. One, you can create a new variable in the online analysis tool (click the “Create Variables” button on the top left of the page). This will allow you to create a unique MIGPUMA1 - MIGPLAC1 combination variable to include in the table. Two, you can extract these variables (along with age and any other variables you’d like) using the IPUMS data extract system.

I hope one of these options helps. Let us know if you have any additional questions.