art photo

DSDR KB

Q:  

I am having trouble merging data from 1990 summary data at the census tract level to a crosswalk from Mable/Geocorr.

A:  

Your problem is that census tract is represented with a decimal point in Mable/Geocorr and with an implied decimal point in data from the Census Bureau:

109.01 vs 10901

It is probably easiest to just multiply the former by 100 and then combine state, county, and tract into a geoID:

Tractx = Tract * 100;
GeoID = (St * 1000000000) + (County * 1000000) + Tractx;

Related Question Groups: