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:


W A R N I N G

If you are reading this, it may be that you are using rather old web browsing software that does not support modern international Web technology standards. For a better experience of the Web and this site in particular, please upgrade your web browser software. The following are good choices:

Firefox
Opera
Safari