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

Overview

Now all grown up and ready to take on the world, SAS software's ability to get at just about any data source, massage, cajole, beat, cleanse and transform information and then make it sing and dance in the tool of preference makes SAS the ideal choice for modern decision-support applications. So which tools, technologies and/or approaches can be used for ETL and which make sense for any given application? This paper explores the world of ETL from the perspective of the tasks that the programmers have to accomplish and compare using Base SAS tools versus Data Integration Studio (or as it is now known - SAS Data Integration Studio).