This paper describes a process that is used in a SAS data warehouse implementation. Data model documentation of a SAS data warehouse (in Microsoft Word or Excel) serves as a feed to a SAS program that performs Extract-Transform-Load (ETL). Coding techniques are presented for applying SAS formats, informats, and labels to SAS data warehouse tables. It proved to be extremely efficient during development, when data models often undergo changes and modifications. This suggested approach significantly speeds up the implementation of data warehouses.
Related white papers
Active Ethernet I/O: A New Generation in IP-Based Data Acquisition and Control
Network hosts typically have to poll the I/O server repeatedly in order to obtain remote sensor data over an Ethernet network. This white paper presents a new approach to IP-based...
Ethernet Network-Based DAQ and Smart Sensors for the OPERA Long-Baseline Neutrino Experiment
This paper proposes a data acquisition scheme for the OPERA long-baseline neutrino experiment based exclusively on Ethernet. The expected data rate allows the use of an Ethernet capable device close...
SGER: Computer-Assisted Interpretation of Citizen Input in Rebuilding Lower Manhattan
Computer-mediated communication, specifically facilitated by the Internet, offers new channels for citizens to express their views to elected officials, government agencies, and civic associations. Individuals have embraced email, mailing lists,...
Streamlining Accident Data Acquisition, Communication, and Analysis for Chinese Highways
This paper proposes and tests a streamlined accident data acquisition, communication and analysis system to improve Chinese highway safety program. A GPS/GIS based data logger is designed to identify the...
Infrastructure Management Technology Audit: IBM Tivoli - Tivoli Intelligent Orchestrator and Tivoli Provisioning Manager (Version 2.1)
Tivoli Intelligent Orchestrator (TIO) and Tivoli Provisioning Manager (TPM) implement automated policy-based management of data centre resources, allowing customer adoption of IBM's on demand strategy within the data centre. Infrastructure...
Reference Data Management Now!
This webcast helps one learn about the best practices for the full cycle of reference data management - from data acquisition through "golden source" data distribution. The webcast helps one...
The Future of Mobile Survey Data Collection in Natural Resource Surveys
This paper presents 3 scenarios that present the full range of our interdisciplinary Digital Government research program. The first scenario describes a conceptual framework for accessing, using and collecting geospatial...

