BookmarkSubscribeRSS Feed
arpit
Calcite | Level 5
What is the difference between extract and loader in sas ?

Thanks in advance.
4 REPLIES 4
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Suggest starting with the SAS support http://support.sas.com/ website.

Scott Barrry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:
sas etl extract load site:sas.com
arpit
Calcite | Level 5
Dear Sbb,

I go through the site that given by u.but i couldn't find the exact difference .So please help me.

Thanks and Regards,

Arpit
Cynthia_sas
SAS Super FREQ
Hi:
Perhaps more than documentation, using a simple dictionary would help.

For EXTRACT, from Dictionary.com:
"4. to take or copy out (matter), as from a book.
5. to make excerpts from (a book, pamphlet, etc.)."

Of course, since you are dealing with Tables in the ETL or DI Studio, what you are "extracting" is data from a SOURCE table. And, as it says in this user group paper:

"The extract node is one of the simplest tools that DI Studio 9.1.3 provides. The code it generates is generally just creating a view as a SQL select."

( http://support.sas.com/resources/papers/proceedings10/039-2010.pdf )

And for LOAD, from Dictionary.com:
"20. to place (film, tape, etc.) into a camera or other device: He loaded the film into the camera.
21. to place film, tape, etc., into (a camera or other device): How do you load this camera?"

Since you are dealing with data tables in the ETL or DI Studio, what you are "loading" is data from a SOURCE table into a TARGET table.

The acronym "ETL" is an industry-wide term -- meaning EXTRACT, TRANSFORM, LOAD. For example, Wikipedia has a very clear description of the concepts:
http://en.wikipedia.org/wiki/Etl

And within the context of SAS, you do the "extracting, transforming and loading" using SAS programs, or using SAS ETL Studio (older product) or using the new product, SAS DI (Data Integration) Studio.

If you are using the older ETL user's guide, the documentation is here:
http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/etl_ug_8238.pdf

On page 6 of the ETL Studio documentation, it has this explanation of the relevant terms:

Extract data from sources such as SAS data sets,
DBMS tables, and enterprise applications.

Transform the data before writing it to the target
data stores. For example, you might change the
structure of your data by joining the contents of
several tables into one table.

Load the transformed data into the target data
stores.

I would suggest that you read the ETL Studio User's Guide (or the DI Studio User's Guide) in order to familiarize yourself with how ETL Studio works and how the terms "extract" and "load" are used in the context of ETL Studio.

cynthia

BTW, it is possible, but unlikely, that the folks who use ETL Studio or DI Studio would also use SAS Enterprise Miner (used for Data Mining) or SAS Text Miner (used for Text Mining). So this is really not the best forum for posting your question. Since you generally use the DI Studio (or ETL Studio) within the context of the SAS BI Platform, any of the forums devoted to the BI process/products (such as Web Report Studio or even the Enterprise Guide forum would have been better places). Generally, it is a good idea to read the description of the forum purpose and figure out which one best suits your question. If you do not find a forum for your product or particular usage, that is sometimes an indication that your question is more appropriate for Tech Support.
nancyr_sas
Calcite | Level 5
Just wanted to follow up with those posting to this thread that there is now a new SAS discussion forum dedicated to topics around ETL, DI Studio, Data Quality, and Data Integration. You can find it in the same area, titled SAS Enterprise Data Management & Integration.

thanks!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 932 views
  • 0 likes
  • 4 in conversation