Abstract: When using the SAS® System to create data listings for a clinical study, RTF output can range in size from one page to thousands of pages. In the past, this output was evaluated for accuracy using either the process of parallel programming and manual evaluation of selected records, or a comparison of output data sets using PROC COMPARE. While manual checks of long listings are demanding, they help identify errors such as truncation or incorrect formats that can be missed in a purely programmatic approach. The LISTCOMP macro extracts data directly from an RTF file, compares it to a parallel programmer’s data set, and then provides a summary of each of the columns in the listings. Use of the macro is not dependent upon the version of SAS, but implementing the macro may require a moderate level of programming expertise. This approach not only ensures that the actual RTF output matches the parallel programmer’s output, but that the reporting of information displayed in the RTF output allows for rapid review and identification of values that are impossible, incorrectly formatted, unformatted, or truncated. The LISTCOMP macro both reduces the validation time needed and increases the likelihood that problems in the output are identified.
Publication Year: 2013
Publication Date: 2013-01-01
Language: en
Type: article
Access and Citation
AI Researcher Chatbot
Get quick answers to your questions about the article from our AI researcher chatbot