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 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.