SAS - SAS® Viya® Programming Specialist

Curriculum

Module 1: Programming in SAS Viya Concepts (5-10%)

• Describe the SAS Viya architecture.
• Explain when to use the CAS server for programming tasks.

Module 2: Managing Data with CAS Enabled Procedures (10-15%)

• Explain how to access and use CAS Libraries (caslibs).
• Describe how to load data into In-Memory Tables.
• Describe how to save and drop In-Memory Tables.
• Describe CAS column data types.

Module 3: DATA Step and SQL programming in CAS (10-15%)

• Explain how SAS determines where code executes.
• Explain threading within the SAS DATA step.
• Update DATA step code to run in CAS.
• Update PROC SQL code to run as PROC FEDSQL code.

Module 4: CAS-Enabled Procedures and User Defined Formats (5-10%)

• Identify common procedures that run only on the Compute Server.
• Use common procedures that run in both the CAS and Compute Server.
• Use Common summary procedures that run only in CAS.
• Discuss how user-defined formats are used and stored in CAS.

Module 5: CAS Language Basics (15-20%)

• Describe the CASL programming language.
• Create and manipulate CASL variables.
• Use arrays in CASL programs.
• Use dictionaries in CASL programs.
• Capture the results returned from CAS actions.
• Use source blocks in CASL programs.

Module 6: Access Data with CAS Actions (5-10%)

• Use CAS actions to access and explore data sources.
• Use CAS actions to manage in-memory tables.

Module 7: Explore and Validate Data with CAS actions (5-10%)

• Investigate in-memory data table properties and contents.
• Investigate results table properties and contents.

Module 8: Prepare Data with CAS Actions (20-25%)

• Update the contents of in-memory tables with the table.
• Create a copy of in-memory tables with the table.
• Convert character to numeric columns.
• Use data preparation action sets.
• Modify table attributes with the table.
• Resolve missing values in tables with the data.
• Transpose tables with the transpose.

Module 9: Analyse and Summarize Data with CAS Actions (5-10%)

• Summarize data with CAS actions.
• Create Visualizations and Reports.