Base SAS versus SAS Data Integration Studio

From sasCommunity
Jump to: navigation, search
Paper 099-31

Base SAS® vs. SAS® Data Integration Studio: Understanding ETL and the SAS Tools Used to Support It

Title

Base SAS vs. ETL Studio: Understanding ETL and the SAS tools used to support it Download Paper,

Author

Gregory S. Nelson - ThotWave Technologies, LLC.

Abstract

Every data warehouse, data mart and data hut needs it. Every good business intelligence interface depends on it. It has been the hallmark of what SAS programmers have done for over 30 years – the ability to beat data into submission (a.k.a. ETL - extract, transform and load data). Now all grown up and ready to take on the world, SAS’ ability to get at just about any data source, massage, cajole, beat, cleanse and transform information and then make it sing and dance in your tool of preference makes SAS the ideal choice for modern decision support applications.

Audience

SAS Programmers, Managers

Keywords

ETL Studio, BASE SAS, SQL, data warehousing, slowing changing dimensions, ETL

Location Delivered

San Francisco, CA

Product

SAS Data Integration Studio, Base SAS

Download Paper

MEDIA:BASE_SAS_vs._ETL.pdf

Download Presentation

MEDIA:BasevsDIStudio.ppt