Title: Using Visual Basic for Application to Produce Table of Contents from SAS Output List Files
Abstract: The paper is a continuation and extension of our earlier work on applying Visual Basic for Application (VBA)® procedures in the Microsoft Word® to manipulate SAS® output Table/Listing (TL) files [Zeng & Li, SAS Global Forum 2010]. In this paper, we shall explore further to show how to assemble SAS list files into a single file by the order of their table/listing numbers, and produce Table of Contents (TOC) from SAS output Table/Listing (TL) files. All these manipulation tasks on SAS list files shall be accomplished by clicking buttons to execute VBA macros. The testing of the VBA macros was verified in a Windows Operating System PC with Microsoft Office 2003 or 2007.
Publication Year: 2011
Publication Date: 2011-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