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

Glossary

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 ;

Home Page
previous step            next step
back to top
Who We Are
Acknowledgements
Contact Us
This work was funded by the National Institutes of Health (1RO1HD36865-01) via the National Institute of Child Health & Human Development (NICHD) and the Office of Behavioral & Social Science Research (OBSSR).
Copyright © 2004 by the President and Fellows of Harvard College - The Public Health Disparities Geocoding Project.