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