Using SAS Software and Visual Basic for Application to Dynamically Manipulate SAS List Files

Download Now Date Added: Mar 2010
Format: PDF

This paper demonstrates how to apply Visual Basic for Application (VBA) procedures in the Microsoft Word to dynamically manipulate SAS output list files. In the paper, the author shall show how to convert SAS list files into Rich Text Format (RTF) files with appropriate page setup; extract the first page of each SAS list file; assemble all RTF files into a single file and send print command to Microsoft Word from SAS. All the manipulation tasks shall be accomplished by executing an integrated SAS macro which dynamically interacts with VBA subroutines. The code of both the SAS and VBA macros are included in the paper.