NAACCR | North American Association of Central Cancer Registries

This SAS code calculates the great circle distance between the locations of cases at the time of diagnosis and the locations of treatment facilities. Case locations are taken from NAACCR items 2352 (latitude) and 2354 (longitude) in a NAACCR v10 or v11 record layout file. The program can use either source (unconsolidated) or consolidated case records as input. A second input file contains facility IDs, latitude, and longitude.

• Great Circle Distance Calculator SAS Application
• Great Circle Distance Calculator Documentation (Word)
• Great Circle Distance Calculator - How to add coordinates to an GIS attribute table (PDF)
• Great Circle Distance Calculator - Overview on how to use it (PPT)

This algorithm uses information on Asian race Not Otherwise Specificed (NOS) as reported to the cancer registry based on information from the medical record, and using gender, birthplace, first name, and surname (including maiden name, when available), assigns an Asian NOS race status to a more specific Asian race group.

• NAPIIA v1.2.1, Reviewed September 13, 2011 (PDF)
• Note: NAPIIA is now run as part of the NHAPIIA algorithm.

This algorithm combines NHIA v2.2.1 and NAPIIA v1.2.1 into a single SAS program.

• NHAPIIA SAS Code and Related Files Reviewed September 27, 2011 (Zipped)

This algorithm uses information on ethnicity from the medical record, information reported to the cancer registry, and an evaluation of the strength of the birthplace race and surname (including maiden name, when available) associated with Hispanic ethnicity status.

• NHIA v2.2.1, Updated September 13, 2011 (PDF)
• Note: NHIA is now run as part of the NHAPIIA algorithm.

This tool describes and provides macro-driven formulae, in a Microsoft Excel workbook, to calculate completeness of case ascertainment based on observed cancer incidence, death rates, and a comparison of standard rates of incidence and mortality in the United States.

• NAACCR Method to Estimate Completeness Workbook (1995-2009)

This program is used with a NAACCR standard data exchange file format with confidential information, including a census tract identifier. The program will link the census tract identifier with the percent of the residents in the census tract that live below the poverty level. This information is based on the 2000 US Census. The program will output two variables that will be attached to every registry record inputted: the xx.x% poverty for the census tract, and a second variable that groups the exact percents into four categories: less than 5% poverty, 5%-9.9% poverty, 10%-19.9% poverty, and 20% or higher poverty.

• Poverty and Census Tract Linkage SAS Program

The Record Uniqueness Program was developed by Howe, Lake, and Shen to assess electronic data files for risk of confidentiality breach based on unique combinations of key variables.

• An Executable Record Uniqueness Program for Moderate-Sized Files (Zipped EXE)
• A SAS Program for Record Uniqueness for Large Files (Zipped SAS Macro)
• A description of the method (PDF)

The rural-urban continuum program is a windows-executable program that assigns codes from the rural-urban continuum to the county of residence. The program assigns two codes to each case: one for the 1993 standard variable and another according to the 2000 definitions. Once the file is downloaded and unzipped, it will run independently. Documentation and steps to run the algorithm are included within the program.

• Rural-Urban Continuum Program (Self-Extracting EXE)