Title: Automate Compiling Clinical Appendix Tables and Listings into a Review Package with a Hyper-Linked Table of Contents
Abstract: Compilation of a large number of tables and listings in clinical studies from SAS outputs into a user-friendly review package with a hyper-linked table of contents (TOC) is a labor-intensive process in clinical study reporting. A complete TOC is not only a key for publication purpose, but also serve as a key element to both medical and statistical review at every stage of a clinical trial. This paper introduces a SAS macro and Microsoft VBA macros that are executed under SAS environment to automatically generate such a review package with a hyper-linked TOC. Specifically in our case, each of TOC entries contains leading dots before a given page number for a clinical report. This format also applies to a table of all footnotes and titles as separate files. Furthermore, the selections to compile such a review package from clinical tables and listing and their ordering in the package will be determined by a userspecified external file, which lists the file names of SAS outputs for packing and whose ordering in the file will be the one for the package. By default, all files will be packed in an alphabetical order of file names. For debugging and Q/A purposes, the program sends a series of appropriate messages to help the user to track how the SAS list files were generated. The macro works both PC environment and UNIX platform while its VBA macros, however, have to be executed in Windows environment.
Publication Year: 2008
Publication Date: 2008-01-01
Language: en
Type: review
Access and Citation
AI Researcher Chatbot
Get quick answers to your questions about the article from our AI researcher chatbot