| Publisher | SAS Institute | ||
|---|---|---|---|
| Format | 126.5KB PDF | Date added | 14 Apr 2004 |
| Topics | Knowledge and Data Management | ||
| Downloads | 111 | ||
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.
Did you find this white paper useful?
31 out of 45 users found this white paper useful
Related white papers
Maxmise IT Flexibility and Lower Costs With Grid Computing
This document discusses grid computing: Oracle's definition of it, the benefits of it, and the elements that comprise an Oracle Enterprise Grid Computing environment. It also highlights an Oracle customer's...
Ten Things to Know About Grid Computing on Windows
This Oracle whitepaper offers insights into Oracle Grid. A grid allows a business to add capacity, cheaply, whenever it is needed. What's more, an Oracle Grid can help you gain control...
The ROI of Data Governance - A Revenue Generation Perspective
"Concentrating on increasing revenue necessarily means paying attention to metrics such as return on investment (ROI). This white paper from Gwen Thomas of the Data Governance Institute provides a practical...
Building a Data Quality Scorecard for Operational Data Governance
" Operational data governance is the manifestation of the processes and protocols necessary to ensure that an acceptable level of confidence in the data effectively satisfies the organization's business needs....
MDM Components and the Maturity Model
Any effective master data management program requires a mix of technologies to achieve success. This white paper by David Loshin provides a conceptual outline of technical MDM components and examines...
Ovum Report: IBM Simplfies Service Management to facilitate business and IT
All too often, companies find their IT infrastructure is fragmented and confused. Different parts of the business have different silos of data and applications, with no integrated vision joining them...
Massively Scalable NAS - Pre-Empting Tomorrow's Data Overload with Today's Technology
HP is launching the HP StorageWorks 9100 Extreme Data Storage System that solves challenges such as extreme scability, manageability and affordability and creates new business opportunities. HP is going to...
