SAS Programming for Data Integration Developers

SAS Programming for Data Integration Developers (Live Web)

Duration: 3 half-day sessions
Please note the System Requirements below.
Course fee: $475
EPTO units: 0.9
CEUs: 0.9

This course is for data integration developers who prepare data for data warehousing. The course discusses programming techniques that are designed to give programmers the background needed to be able to understand the code generated by SAS Data Integration Studio.

Learn how to

read various types of data into SAS data sets
create SAS variables and recode data values
create listing reports
transform character, numeric, and date variables
query and subset data using PROC SQL.

Who should attend

Data integration developers who need to learn SAS programming techniques

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

There are no formal prerequisites for this course.

Course Contents

The DATA Step

structure of SAS programs
SAS data sets
creating a permanent SAS data set
writing a SAS DATA step
creating a DATA Step View

Producing List Reports

getting started with the PRINT procedure
sequencing and grouping observations
using special WHERE statement operators (self-study)
customizing report appearance
formatting data values
creating HTML reports

Creating SAS Data Sets

reading raw data files using column input and formatted input
examining data errors
assigning variable attributes
changing variable attributes (self-study)
reading Microsoft Excel spreadsheets (self-study)

Programming with the DATA Step

reading SAS data sets and creating variables
executing statements conditionally
dropping and keeping variables (self-study)
reading date fields from Microsoft Excel spreadsheets (self-study)

Software

This course addresses SAS Data Integration Studio.

Course Materials

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 follow 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 not be able to participate in the course exercises. Using your organization's BI environment is not an option for completing the course exercises.

Share Your Thoughts

Are there additional classes or topics you would like to see as Live Web classes? Let us know by adding to our Interest List.

This page was created using SAS software.

-	Public
-	On-site training
-	One-to-one Mentoring
-	Courses by Industry Experts
-	Targeted Learning
-	ABM Training
-	TPS Service
-	Find a Course
-	Register now
-	Course list
-	Curriculum paths
-	Locations
-	Special Offers