Title: Using Dynamic Data Exchange and Table-Driven Programming to Manage Excel Files
Abstract: In clinical trials, Microsoft Excel is widely used to document programming requirements. Those documents are frequently updated over time. It is quite time consuming and often challenging for programmers to keep track the changes of the requirement documents. As a result, the requirement changes might not be communicated efficiently among the team and the implementation of those changes might be delayed or overseen. The Excel Manager is a SAS macro with the integration of the following techniques. The Dynamic Data Exchange (DDE) is used to import Excel worksheets into SAS. The table-driven programming technique is applied to pass metadata from the source to the subsequent programs. The COMPARE and REPORT procedures are used to extract the version change information and generate color-coded RTF reports to reflect the changes of the Excel file for records addition, deletion, and update. The Visual Basic script is developed to send email reminder to users via Simple Mail Transfer Protocol (SMTP) server for new version release.
Publication Year: 2007
Publication Date: 2007-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