cbgoodman/countyfips

Stata program for merging U.S. county identifiers

countyfips's Issues

Issue when matching on state and county FIPS

I believe that after the latest update, the dataset contains two separate observations for counties named "St. ...": one starting with St. and another one starting with St. This is great, but I believe this is problematic when matching on State and County fips: for instance, when I run

countyfips, statefips(my_state_fips_codes) countyfips(my_two digit_county_fips_codes)

I get the following error:

variables state_fips county_fips do not uniquely identify observations in the using data
r(459)

I was able to verify that the "St. ..." were the problematic observations, by running the following on the master countyfips data:

bysort state_fips county_fips: gen counter = _n
tab counter

I get the that 30 counties have a repeated observation. All of these are indeed counties named "St. ... "

Linux Backstage County Dataset Update

Hi Chris,
(Or person who follows the bugs for countyfips)
I was getting an error in the Linux platform of UGA supercomputer, but not in my personal computer with a sample of the data. After checking my dataset I decided to run something very simple:

---

clear all
set obs 1
gen fips=1001
countyfips,fips(fips)
*** The output
(all newnames==oldnames)
(variable fips was float, now double to accommodate using data's values)
variable fips does not uniquely identify observations in the using data
r(459);

---

This does not happen in my laptop running in stata for windows. I solved the issue moving the DS to Linux, but it is a rather cumbersome and it loses the straightforwardness of the command

I hope thought you might want to know.
Best,

Felipe L