Applied Data Engineering for Generative & Agentic AI Systems

Reusable Programming with SAS Macro Language for Data Automation (SAS Macro Language 1: Essentials)

✔ Perform text substitution in SAS code.

✔ Use macro variables and macro functions.

✔ Automate and customize the production of SAS code.

✔ Conditionally or iteratively construct SAS code.

✔ Write self-modifying, data-driven programs.

Performance Optimization for Data Pipelines (Accelerating SAS Code on the SAS Viya Platform)

✔ Run traditional SAS code on the SAS Viya platform.

✔ Connect to SAS Cloud Analytic Services (CAS).

✔ Access and use caslibs on the CAS server.

✔ Load SAS data sets, Parquet files, CSV files, Microsoft Excel files, and DBMS tables into CAS.

✔ Save distributed CAS tables back to permanent storage in various formats like SASHDAT, Parquet, and CSV.

✔ Modify DATA step code to execute in CAS.

✔ Modify SQL procedure code to execute in CAS using FedSQL.

✔ Use CAS-enabled procedures.

✔ Write CASL code to execute actions on the CAS server.

No-Code Data Access and Transformation in SAS Studio (Managing and Querying Data Using Flows in SAS Studio)

✔ Access and manipulate data of various types.

✔ Create queries that filter and sort data, compute new columns, and join multiple tables.

✔ Enhance flows to boost productivity and efficiency.

Data Engineering with SAS Studio: ETL, Quality & Integration (Using SAS Studio Engineer Steps in SAS Studio Flows)

✔ Use SAS Studio flows to work with database tables.

✔ Combine data of various types using multiple loading methods.

✔ Implement and maintain slowly changing dimensions in database tables.

✔ Integrate SAS Intelligent Decisioning in existing flows.

✔ Standardize, profile, and parse data with data quality steps.

✔ Perform entity resolution.

✔ Leverage SAS Studio Analyst steps for data management operations.

Low-Code Customization in SAS Studio for Dynamic Workflows (Developing Custom Steps with SAS® Studio Analyst)

✔ Create custom steps and use them in SAS Studio flows.

✔ Design custom step interfaces

✔ Implement dynamic user interfaces, including prompt hierarchies, that prompt users to enter control values.

✔ Establish dependencies to control the visual interface and the program execution.

Visual Analytics Dashboards for Data Exploration (SAS Visual Analytics 1 for SAS Viya: Basics)

✔ Get started building reports using SAS Visual Analytics.

✔ View reports using SAS Visual Analytics and other supported applications.

✔ Access data loaded into CAS and navigate the SAS Visual Analytics interface.

✔ Manage and create data items, work with multiple data sources, and sort, filter, and rank data.

✔ Explore data using objects.

✔ Create reports using objects.

✔ Analyze geographic data using geo maps.

✔ Enhance reports with display rules.

✔ Design interactive reports by modifying viewer capabilities and by adding prompts, actions, and links.

✔ Discover best practice recommendations for report design using SAS Visual Analytics.

Exploring Generative AI, Agentic AI and Prompt Engineering using SAS

✔ Introduction to Gen AI and the AI Landscape.

✔ Machine Learning and Generative AI.

✔ Introduction to Large Language Models.

✔ Generative AI Systems.

✔ Examples of Generative AI Technologies.

✔ The Evolution of Agentic AI.

✔ SAS’ Approach on Generative AI and Agentic AI.

✔ The AI Challenge: Balancing Risk and Reward.