Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have two datasets- matching years, different sources. They are matchable by FIPS code, but my problem is 1) that the first data set, from which I am drawing my independent variable data, only has the five-digit FIPS code data, and my other data set has information disaggregated down to the eleven digit level. Any thoughts on combining these more disaggregated data?

share|improve this question
    
For people not from the US: en.wikipedia.org/wiki/FIPS_county_code –  sgrieve Oct 18 '12 at 8:01
add comment

1 Answer

You easiest answer is to create a new field in your table with the longer value; than extract the left 5 characters and insert them into the new field. Then you can join on that field without having made any integrity changing updates to the underlying data.

Any database has a function to select a substring of a value.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.