NAACCR v12 SAS Translation Tool
The
IT committee is pleased to provide SAS code to aid in reading and writing data
files
in the NAACCR V12 record format. In the spirit of NAACCR collaboration,
this tool
has been developed, refined and tested by numerous NAACCR members. We want
to
express our thanks all who have contributed to this effort.
The code template below can be used by proficient SAS programmers to
efficiently
and accurately access data in the new V12 format. Reading and writing to
ASCII V12
formats are both provided. Various sections and options are included - users simply
comment out sections which are not applicable for their specific needs. Two
alternate
labeling formats are provided, and the three most often used record types
(Incidence,
Confidential and Text) are accommodated. Testing has been performed on the
code and
we are comfortable that it is reliable and ready for use.
As you use the tool, we appreciate any feedback or comments you have.
Contact rpinder@usc.edu with your thoughts.
NAACCR v12 Microsoft Access Translation Tool
Similar to the SAS tool above, the IT Committee presents a product written for Microsoft
Access. We thank David O’Brien at the Alaska Cancer Registry for providing the tool, and all the NAACCR
members who have tested and given feedback. Users familiar with Access will be able to import a
NAACCR v12 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 v12 file. Anyone with questions about this tool should contact David O’Brien at the
Alaska Cancer Registry at david.obrien@alaska.gov with questions or thoughts.