Budget Living with Pseudo ETL
Creating your own ETL tool through SAS®
David Steves, SunTrust Bank, Atlanta, Georgia
Denise Figliozzi, SunTrust Bank, Atlanta, Georgia
In today's world data processing needs to run faster, better, and more efficiently. The push for the latest data is
evermore important and can be facilitated through the use of an ETL tool. The acronym ETL stands for extraction,
transformation, and loading. Companies evaluate different ETL tools to purchase. But, is it truly necessary? Your
company may already have some of the basic SAS components that you can use as an ETL tool.
This paper will go over three components of the ETL (Extraction, Transformation, and Loading) and illustrate which
SAS components can be utilized.
Everyday company executives wake up to make business decisions based on the most current available data. This
data will need to be processed and synthesized to make sound business decisions. One of the many tools used to
collect this type of information is called an ETL. Currently, many software companies offer ETL tools, but, is it an
absolute necessity to purchase one? Companies have become more cost conscious over the years and tend to
procrastinate on expensive purchases. Well, your company may already have the SAS components necessary to
create an ETL.
In the olden days, we did not have any data processing called ETL. The creation of synthesized data was called data
processing. These ETL tools may be faster and collectively better, but, how fast is fast? Savvy SAS programmers
can generate quick results and can emulate an ETL tool. In this paper, we will illustrate the extraction process, the
transformation process, and the loading process while detailing the associated SAS components utilized.
Extraction for our purposes means: the moving of data from location A to location B. Many years ago we referred to
the extraction process as “pulling data.” We can easily pull data f