Status:Closed    Asked:Oct 15, 2014 - 10:44 AM

Is there a way to pull data for more than one state at a time?

I am trying to pull migration data for specific occupations and I'd like to pull all states, but I'm limited to pulling one state at a time. I'm using the following queries for my data:

Row: occ (r: 1=1005-1030;110;300;360;1050-1060;1105-1107;1200- 1550 ;1600-1760;1820;1860-1930;1965)

Column: migrate1

Filter: statefip()

Do you have the same question? Follow this Question

Staff Answer




You will want to add the variable statefip as the Control variable. This will generate a table for each value of statefip, as well as a cumulative table for all values of statefip. Keep in mind that some states were not individually identified prior to 1977, so you may want to add a Selection Filter for year, e.g. year(1977-2014). Otherwise, you will see statefip values above 56, which correspond to the defunct state grouping codes.

I hope this helps.


Oct 15, 2014 - 01:02 PM

Report it


Potential effects of sample size expansion in CPS: March 2000 to March 2001
Should you use WTSUPP and the replicate weights for state level analysis usin...
Why are not all the "not in the labour force" categories filled for the EMPST...
When was contingent worker supplement data (1995 and 2005) added to IPUMS-CPS...
I am getting strange numbers for NIU persons in the sixties, especially 1962-...
Login   |   Register

Recently Active Members

View More »

Share |