This course focuses on DS2, which is a fourth-generation SAS proprietary language for advanced data manipulation. DS2 enables parallel processing and storage of large data with reusable methods and packages. This course is designed for programmers with large data who want to use modern programming techniques and structures.

Learn how to

• identify the similarities and differences between the SAS DATA step and the DS2 DATA step
• convert a Base SAS DATA step to DS2
• create DS2 variable declarations, expressions, and methods for data conversion, manipulation, and conditional processing
• create user-defined and predefined packages to store, share, and execute DS2 methods
• create and execute DS2 threads for parallel processing
• leverage the SAS In-Database Code Accelerator to execute DS2 code outside of a SAS session
• execute DS2 code in the SAS High-Performance Analytics grid using the HPDS2 procedure.

Who should attend Experienced SAS software users who want to use modern programming techniques for manipulating large data Formats available Duration
: 3 half day sessions
: 4 half day sessions

This course is not appropriate for beginning SAS software users. Before attending this course, you should have several months of SAS programming experience, or have taken the course. You should also have a solid background in ANSI SQL: 1999.

This course addresses Base SAS software.

Introduction

• introduction to DS2
• course logistics

Getting Started

• Hello, World
• basic DS2 syntax
• converting a Base SAS DATA step to a DS2 DATA step

DS2 versus Base SAS DATA Step

• similarities to the Base SAS DATA step
• DS2 "missing" features

New Data Types and Syntax

• data types
• automatic data type conversion
• expressions
• selected functions

Methods, Packages, and Threads

• methods
• user-defined packages
• predefined packages
• threads

DS2 Unleashed

• SAS In-Database Code Accelerator
• introduction to the HPDS2 procedure

Learning More

DS2EHD.