-------------------------------------------------------------- Old Variable New Variable -------------------------------------------------------------- Age dAge Ancstry1 dAncstry1 Ancstry2 dAncstry2 Avail iAvail Citizen iCitizen Class iClass Depart dDepart Disabl1 iDisabl1 Disabl2 iDisabl2 English iEnglish Feb55 iFeb55 Fertil iFertil Hispanic dHispanic Hour89 dHour89 Hours dHours Immigr iImmigr Income1 dIncome1 Income2 dIncome2 Income3 dIncome3 Income4 dIncome4 Income5 dIncome5 Income6 dIncome6 Income7 dIncome7 Income8 dIncome8 Industry dIndustry Korean iKorean Lang1 iLang1 Looking iLooking Marital iMarital May75880 iMay75880 Means iMeans Military iMilitary Mobility iMobility Mobillim iMobillim Occup dOccup Othrserv iOthrserv Perscare iPerscare POB dPOB Poverty dPoverty Pwgt1 dPwgt1 Ragechld iRagechld Rearning dRearning Relat1 iRelat1 Relat2 iRelat2 Remplpar iRemplpar Riders iRiders Rlabor iRlabor Rownchld iRownchld Rpincome dRpincome RPOB iRPOB Rrelchld iRrelchld Rspouse iRspouse Rvetserv iRvetserv School iSchool Sept80 iSept80 Sex iSex Subfam1 iSubfam1 Subfam2 iSubfam2 Tmpabsnt iTmpabsnt Travtime dTravtime Vietnam iVietnam Week89 dWeek89 Work89 iWork89 Worklwk iWorklwk WWII iWWII Yearsch iYearsch Yearwrk iYearwrk Yrsserv dYrsserv Mapping: In this step we map all of the old values for variables with prefix 'd' to new values. The mappings for the variables dAncstry1, dAncstry2, dHispanic, dIndustry, dOccup, dPOB were designed to correspond to a natural coarsening of the original values based on the information in the file coding.htm. The remaining variables are continuous valued variables and the mapping for these variables was chosen to make variables that were fairly uniformly distributed across the states (quantiles). The precise mappings are specified in the file USCensus1990.mapping.sql. This file contains all of T-SQL procedures used to map the variables. These procedures can be used directly in SQLServer to map the original values or translated to some other language. -------------------------------------------------------------- Variable Procedure -------------------------------------------------------------- dAge discAge dAncstry1 discAncstry1 dAncstry2 discAncstry2 dHispanic discHispanic dHour89 discHour89 dHours discHours dIncome1 discIncome1 dIncome2 discIncome2to8 dIncome3 discIncome2to8 dIncome4 discIncome2to8 dIncome5 discIncome2to8 dIncome6 discIncome2to8 dIncome7 discIncome2to8 dIncome8 discIncome2to8 dIndustry discIndustry dOccup discOccup dPOB discPOB dPoverty discPoverty dPwgt1 discPwgt1 dRearning discRearning dRpincome discRpincome dTravtime discTravtime dWeek89 discWeek89 dYrsserv discYrsserv