ETL processing using SAS Data Integration (DI) Studio

SAS Data Integration Studio is a visual design tool that simplifies the construction, execution and maintenance of enterprise data integration processes. Powerful, in-depth data transformation logic is provided in an easy-to-use, wizard-driven interface, enabling one or more developers to rapidly build, schedule, run and monitor a myriad of data integration activities. An easy-to-use interface and built-in impact analysis capabilities lower the cost of building and maintaining data integration workflows, simple or complex.

Why is SAS Data Integration Studio important?

Companies are realizing that in order to succeed they need an integrated view of their data – and SAS Data Integration Studio is the single tool that provides the flexibility, reliability and agility needed to respond to new data integration challenges. Regardless of the project, SAS Data Integration Studio users can respond with speed and efficiency, reducing the overall cost of data integration.

For whom is SAS Data Integration Studio designed?

SAS Data Integration Studio empowers data integration managers and designers to work more efficiently, manage change effectively and deliver high-quality results faster.

Watch this video..

Hands on Workshop on SAS DI Studio..

Other Interesting References…

SAS DI Studio Fact sheet 
SAS Documentation 
SAS® Data Integration Studio and SAS® Macro – Working in Harmony for Data Warehousing Projects 
Base SAS® vs. SAS® Data Integration Studio: Understanding ETL and the SAS Tools Used to Support It

Introduction to SAS

The SAS System known well as Statistical Analysis System, is one of the most widely used, flexible data processing, reporting and analyses tools.

SAS is a set of solutions for enterprise-wide business users as well as a powerful fourth-generation programming language for performing tasks or analyses in a variety of realms such as these:

Analytic Intelligence

General
Data Mining and Statistical Analysis
Forecasting & Econometrics
Operations Research
Quality Improvement

Business Intelligence 
General
Applications Development
Content Delivery
Query and Reporting

Data Warehousing 

General
ETL & Data Quality
Warehouse Management

The core of the SAS System is Base SAS software, which consists of the following:

• SAS language a programming language that you use to manage your data.
• SAS procedures software tools for data analysis and reporting.
• macro facility a tool for extending and customizing SAS software programs and for reducing text in your programs.
• DATA step debugger a programming tool that helps you find logic problems in DATA step programs.
• Output Delivery System (ODS) a system that delivers output in a variety of easy-to-access formats, such as SAS data sets, listing files, or Hypertext Markup Language (HTML).
• SAS windowing environment an interactive, graphical user interface that enables you to easily run and test your SAS programs.

(Source: SAS.Com)

With Base SAS software as the foundation, you can integrate with SAS many SAS business solutions that enable you to perform large scale business functions, such as data warehousing and data mining, human resources management and decision support, financial management and decision support, and others.