Stay in Touch
Not sure what course to take?
Speak with an expert curriculum consultant at 800-333-7660 or send an e-mail.Submit Your Course Requests
Want this course at another location or on a different date? Let us know your course needs.On-site Pricing
Course fee and EPTO/APTO units differ for on-site training.ETL for SAS Activity-Based Management 6.x
|
Classroom duration: 2.0 days Live Web duration: 4 half-day sessions Please note the System Requirements below. Course fee: $1,150 EPTO units: 2.2 CEUs: 1.2 | ||
 |
This course familiarizes you with methods of data extraction, transformation, and loading (ETL) in preparation for SAS Activity-Based Management 6.x.
Learn how to
- set up the SAS Activity-Based Management system for ETL
- use the data schema for creating staging tables
- import model data from staging tables
- map source tables to data fields and properties in the staging tables
- export model data for analysis and reporting.
Who should attend
Database users who prepare source data for import to or export from SAS Activity-Based Management 6.x models
Expand All
Collapse All
Print version
Prerequisites
Before attending this course, you should have completed the Querying and Reporting Using SAS Enterprise Guide course. The ABC Modeling Using SAS Activity-Based Management 6.x course would be helpful and preferred but is not required.
Course Contents
What Is ETL?
Setting up SAS for ETL
Importing Model Data
Data Schema
Mapping Tables
Transforming Data in SAS Enterprise Guide
Exporting Model Data
Exporting for Analysis
Challenge Lab
Setting up SAS for ETL
Importing Model Data
Data Schema
Mapping Tables
Transforming Data in SAS Enterprise Guide
Exporting Model Data
Exporting for Analysis
Challenge Lab
Software
This course addresses SAS Activity-Based Management. You also use SAS Enterprise Guide in this course.
Course Materials
Classroom: Students attend classroom courses in one of our public training centers. You receive
a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.
Live Web: Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials. Students need to download and print the course materials prior to class.
Live Web: Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials. Students need to download and print the course materials prior to class.
System Requirements
For Live Web, you must
- review and meet the general system requirements.
- complete the course exercises through our virtual lab. The virtual lab allows you to access the software used in class over the Internet, so that you do not need this software on your local machine.
- run this
test to connect to a virtual lab session. If firewall problems prevent you from connecting to the virtual lab, then you will need the following software installed and configured in your environment to participate in the course exercises:
- a SAS Activity-Based Management Environment that meets these System Requirements (.pdf)
Share Your Thoughts
Not sure if this course suits your needs or which delivery method is right for you?
Give us a call at 800-333-7660 or send us e-mail.
If you have suggestions for this course or would like for it to be offered at another
training facility, let us know by adding to our Interest List.
This page was created using SAS software.