SAS program to standardize business names

AUTHORS

Nada Wasi, Survey Research Center, Institute for Social Research, University of Michigan
Ann Rodgers, Survey Research Center, Institute for Social Research, University of Michigan
Kristin McCue, US Census Bureau

SUPPORT: [email protected]

DESCRIPTION

This code, for SAS, provides an open-source method to standardize business names. It is the equivalent to the Stata code described in

Wasi, Nada and Flaaen, Aaron, (2015), Record linkage using Stata: Preprocessing, linking, and reviewing utilities, Stata Journal, 15, issue 3, p. 672-697.

For extensive details, please see the draft manuscript.

MAIN FILES

stnd_compname.sas

stnd_compname.sas requires the following SAS macro files and pattern files installed. The pattern files are in the subfolder "PatternFiles".

MACRO FILES

agg_acronym.sas
load_patternfiles.sas
maxlengths.sas
parsing_entitytype.sas
parsing_namefield.sas
set_patdefaults.sas
set_patfile.sas
stnd_commonwrd_all.sas
stnd_commonwrd_name.sas
stnd_entitytype.sas
stnd_nesw.sas
stnd_numbers.sas
stnd_search_replace.sas
stnd_smallwords.sas
stnd_specialchar.sas

PATTERN FILES

P10_namecomp_patterns.csv
P21_spchar_namespecialcases.csv
P22_spchar_remove.csv
P23_spchar_rplcwithspace.csv
P30_std_entity.csv
P40_std_commonwrd_name.csv
P50_std_commonwrd_all.csv
P60_std_numbers.csv
P70_std_nesw.csv
P81_std_smallwords_all.csv
P90_entity_patterns.csv

SAS PROGRAM AND DATA FILES TO REPLICATE EXAMPLE IN THE PAPER

example.sas
fileA.sas7bdat
fileB.sas7bdat