Hi,

I am trying to merge two excel datasets which have unemployment and education data at the US county level (by FIPS code). Both datasets have the same exact number of rows (one for each county) and when I upload them to Stata it works fine. However, when I try to merge them with "merge 1:1 FIPS using educationdata" it keeps keeps telling me "variable FIPS does not uniquely identify observations in the master data". Does anyone know why this may be happening? I also tried m:1 and 1:m (although I think 1:1 is the correct one given I am just adding columns) but I get the same problem.

Thank you very much!

Joan