White Papers

SAS and Microsoft Excel for Tracking and Managing Clinical Trial Data: Methods and Applications for Information Delivery

Overview Microsoft Excel is widely used in the pharmaceutical industry and therefore frequently requested due to familiarity and ease of use. This paper outlines an automated data communication between Excel and SAS programs such as how to consolidate data from multiple Excel files, MS ACCESS files and other data sources, establish a data warehouse by manipulating and integrating information in SAS, and deliver information in Excel format applying Excel templates with reusable macros or by dynamically creating multiple Excel worksheets. Several SAS methods are explored including DATA step, SAS/ACCESS (PROC ACCESS, SQL Procedure, PROC DBLOAD, PROC IMPORT/EXPORT), DDE (Dynamic Data Exchange), and ODS (Output Delivery System).

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
Pharmacyclics
File Format
PDF
Date Published
Oct 7, 2008
Format
White Papers
Topics
Spreadsheets, Business Intelligence - Data Warehousing, Database Management