Knowledge and Data Management White Papers
A Practical Approach to Transferring Data From Microsoft Excel to SAS in Pharmaceutical Research
Overview The need to transfer data from MS Excel into SAS is frequently encountered in pharmaceutical research. Multiple approaches could be taken in the data transfer, such as IMPORT WIZARD, SAS/ACCESS, ODBC, DDE and DBMS/COPY. However, these methods may not handle the data transfer correctly or efficiently, especially when data format inconsistencies are present or multiple Excel sheets are involved. This paper proposes a practical, user-friendly macro solution to this problem that provides many flexible features in the data transfer process.
| Publisher | SAS Institute | File Format | |
|---|---|---|---|
| Date Published | April 2004 | ||
| Format | White Papers | ||
| Topics | |||



