This 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.
Learn how 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.
Who should attend
Experienced SAS software users who want to use modern programming techniques for complex manipulation of large data
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 SAS® Programming 2: Data Manipulation Techniques course. A good understanding of ANSI SQL is also beneficial.
This course addresses SAS/ACCESS, Base SAS, SAS Viya software.
