This High-Performance Data Manipulation with SAS DS2 training course focuses on learning DS2, a fourth-generation SAS language for advanced data manipulation. DS2 blends DATA step and SQL syntax with modern programming structures, and enables parallel processing in Base SAS as well as massively parallel processing environments such as Hadoop and SAS Viya Cloud Analytic Services (CAS). A brief introduction to SAS Viya is included.
By attending High-Performance Data Manipulation with SAS DS2 workshop, delegates will learn to:
- Identify the similarities and differences between the SAS DATA step and a DS2 data program
- Convert a Base SAS DATA step to a DS2 data program
- Create DS2 variable declarations, expressions, and methods for data conversion, manipulation, and conditional processing
- Create user-defined packages and use predefined packages to store, share, and execute DS2 methods and extend the capabilities of the DS2 language
- 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 CAS
- Several months of SAS programming experience
- A good understanding of ANSI SQL is also beneficial
This High-Performance Data Manipulation with SAS DS2 class is ideal for:
- Experienced SAS software users who want to use modern programming techniques for complex manipulation of large data