Hello All,
When I import any of the following files: .csv, .dta, et al I am left with missing FIPS codes in my imported file. Every other variable shows up, except for that one… Could someone please help?
About half of US counties cannot be identified in the ACS public use microdata sample data (this is slightly higher than the proportion that can be identified in the CPS). IPUMS identifies counties, where possible, from other low-level geographic identifiers; the lowest geographic identifier available in the public use data for 1950-forward is a public use microdata area (PUMA). I am linking a blogpost on the topic; the COUNTYICP description page includes a spreadsheet of identified counties in the 1950-forward data as well. I looked at your latest IPUMS USA data extract and did see valid COUNTYICP values included (it looks like just over 40% are assigned to 0, indicating they cannot be identified from the public-use data).