Translation Tools for Volume II
A list of tools which can import and export data in NAACCR Volume II format.
v16 SAS Translation Tool
The code template below can be used by proficient SAS
programmers to efficiently and accurately access data in the new V16 format. Code
to both read and write ASCII V16 format is provided. Various sections and
options are included - users simply comment out sections which are not
applicable for their specific needs. The code supports the three most often
used record types (Incidence, Confidential and Text). Beginning with V14, code
is included to handle data elements which are part of the CDC’s Comparative
Effectiveness Research (CER) and Patient-Centered Outcomes Research (PCOR)
projects. As you use the tool, we appreciate any feedback or comments you have. Contact firstname.lastname@example.org with your thoughts.
v14 & v15 Microsoft Access Translation Tool
An update to the MS Access tool to accommodate v14 & v15 is
included. Users familiar with Access will be able to import a NAACCR v14 or v15 file,
which would then be available as a standard Access table. Once in a table
format, queries can be written to select a subset of data items that could be
transferred to Excel for additional analysis. Records in the table can be
reviewed for quality control (QC), modified, and then exported back out again
as a NAACCR v14 or v15 file. Documentation can be found inside the MSAccess file at
the download link below. Anyone with questions about this tool should contact
David O’Brien at the Alaska Cancer Registry at Contact email@example.com with
questions or thoughts.