Merging IPUMS CPS (ASEC) with ICPSR March CPS data

Hi,

I am using IPUMS CPS years 1964-2001. I am doing an analysis which leverages policy changes at the state level, so I really need data disaggregated by state. I noticed that in the years 1968-1976, IPUMS groups many states together. However, in the ICPSR data, the individual state is available. I have downloaded the ICPSR data for these years, however, I am having a hard time figuring out which variables I could use to match the datasets. This is where I downloaded the data from in case this is helpful: https://www.icpsr.umich.edu/web/ICPSR/studies/6171/datadocumentation

Thanks in advance for any thoughts you might have.

Best,
Annie

If you look at the codebooks for the ICPSR files, you will see the table below in Appendix A (I’ve re-sorted it to illustrate shared codes). As you can see, from 1968-1976, several states share the same code. I checked 1970 more closely. For this year, 30 unique codes are listed in the table below. That matches with the number of codes in the IPUMS CPS data. I also downloaded the ICPSR file for 1970. There were only 30 unique state codes in the data. So it seems the ICPSR data have the same aggregation as the IPUMS data.

State 1968-72 1973-76 1977-87
Connecticut 11 16 16
Massachusetts 19 14 14
Maine 19 19 11
New Hampshire 19 19 12
Vermont 19 19 13
Rhode Island 19 19 15
New York 21 21 21
New Jersey 22 22 22
Pennsylvania 23 23 23
Ohio 31 31 31
Indiana 32 32 32
Illinois 33 33 33
Michigan 39 39 34
Wisconsin 39 39 35
Minnesota 41 49 41
Iowa 41 49 42
Missouri 43 49 43
North Dakota 49 49 44
South Dakota 49 49 45
Nebraska 49 49 46
Kansas 49 49 47
District of Columbia 51 53 53
Maryland 52 57 52
West Virginia 53 57 55
Georgia 54 58 58
Florida 55 59 59
North Carolina 57 56 56
South Carolina 57 58 57
Delaware 59 57 51
Virginia 59 57 54
Kentucky 61 67 61
Tennessee 62 67 62
Alabama 69 69 63
Mississippi 69 69 64
Louisiana 71 79 72
Texas 72 72 74
Arkansas 79 79 71
Oklahoma 79 79 73
Colorado 81 89 84
Arizona 81 89 86
Montana 89 89 81
Idaho 89 89 82
Wyoming 89 89 83
Utah 89 89 87
Nevada 89 89 88
Oregon 91 99 92
California 92 92 93
Washington 99 99 91
Alaska 99 99 94
Hawaii 99 99 95