The Public Health Disparities Geocoding Project Monograph Geocoding and Monitoring US Socioeconomic Inequalities in Health: An introduction to using area-based socioeconomic measures
 WHY? READ MORE HOW TO TRY IT OUT! TOOLS Executive Summary Introduction Publications Geocoding Generating ABSMs Analytic Methods Multi-level Modeling Visual Display Case Example U.S. Census Tract Poverty Data
 STEP BY STEP COMPARISON A step by step comparison of each task of the Case Example, the relevant section of Analytic Methods, and sample SAS code (click here for a pdf version of all 8 steps) Step by Step 1 Step by Step 2 Step by Step 3 Step by Step 4 Step by Step 5 Step by Step 6 Step by Step 7 Step by Step 8
 Step 3: Merge the numerators and denominators by AGECAT and AREAKEY. CASE EXAMPLE ANALYTIC METHODS SAS PROGRAMMING click here to download SAS program For age cells in census tracts where no cases were reported, set the numerator to zero. Once the numerators and denominators have the same structure (AREAKEY x AGECAT), they can be merged together, along with the ABSM data (by AREAKEY). For age cells within areas where no cases were reported, we set the numerator to zero. This type of merging is an example of a SAS matched merge. PROC SORT DATA=Step1b ; BY AREAKEY AGECAT ; RUN ; PROC SORT DATA=Step2a ; BY AREAKEY AGECAT ; RUN ; DATA Step3 ; MERGE Step1b (KEEP=AREAKEY AGECAT COUNT) Step2a ; BY AREAKEY AGECAT ; NUMER=COUNT ; IF DENOM>0 THEN LOGDEN=LOG(DENOM) ; ELSE LOGDEN=. ; IF NUMER=. AND DENOM=>0 THEN NUMER=0 ; IF DENOM>=0 THEN OUTPUT ; DROP COUNT ; RUN ;