SAS PROGRAMMER

SAS Programmers use our powerful, fourth-generation language to access data from a wide variety of sources. They use SAS code to manage data, perform complex queries, create analyses and reports and then present their results in tables and graphs.

Advanced and Specialty Courses:

• Advanced Querying UsingSAS® Enterprise Guide
• SAS® Macro Programming: Advanced Topics
• SAS® Programming III: Advanced Techniques and Efficiencies

SAS® Programming I: Essentials

This course is for users who want to learn how to write SAS programs. It is the entry point to learning SAS programming and is a prerequisite to many other SAS courses. If you do not plan to write SAS programs and you prefer a point-and-click interface, you should attend the Querying and Reporting Using SAS® Enterprise Guide® course.

Learn how to:

• navigate the SAS windowing environment
• read various types of data into SAS data sets
• create SAS variables and recode data values
• create listing and summary reports
• create and combine SAS data sets.

Who should attend: Anyone getting started writing SAS programs

Level II: Fundamentals

Delivery: Classroom

Duration: 3 days

Certification: This course is suggested preparation for the SAS Base Programming exam for SAS®9.

Learn more: support.sas.com/courses/prog1.html

SAS® Programming II: Manipulating Data with the DATA Step

This course is for those who need to learn SAS DATA step programming techniques for processing, controlling, and manipulating SAS data sets. The course builds on the concepts that are presented in the SAS® Programming I: Essentials course and is not recommended for beginning SAS software users.

Learn how to:
control SAS data set input and output
combine SAS data sets
summarize, read, and write different types of data
perform DO loop and SAS array processing
transform character, numeric, and date variables.

Who should attend: Business analysts and SAS programmers

Level III: Intermediate

Duration: 3 days

Certification: This course is suggested preparation for the SAS Base Programming exam for SAS®9.

Learn more: support.sas.com/courses/prog2.html

SQL Processing with SAS®

This course teaches you how to process SAS data using Structured Query Language (SQL).

Learn how to:
query and subset data
summarize and present data
combine tables, including complex joins and merges
create and modify table views and indexes
replace multiple DATA and PROC steps with one SQL query.

Who should attend: SAS programmers and business analysts

Level III: Intermediate
Public course fee: $1,150
EPTO/APTO Units: 2.2
Delivery: Classroom and Live Web
Duration: 2 days
(4 half-day Live Web sessions)
Certification: This course is suggested
preparation for the SAS Advanced
Programming exam for SAS®9.
Learn more:
support.sas.com/courses/sql.html

SAS® Macro Language

This course focuses on the components of the SAS macro facility and how to design, write, and debug macro systems. Emphasis is placed on understanding how programs with and without macro code are processed.

Learn how to:
perform text substitution in SAS code
automate and customize the production of SAS code
conditionally or iteratively construct SAS code
use automatic macro variables and macro functions.

Who should attend: Experienced SAS programmers who have a sound understanding of DATA step processing and who want to write SAS programs that are reusable and dynamic

Level IV: Advanced

Duration: 2 days

Certification: This course is suggested preparation for the SAS Advanced Programming exam for SAS®9.

Learn more: support.sas.com/courses/macr.html