SAS SME Training

SAS Programming, SAS Administration and SAS Viya Training

Introduction to SAS and Basic Concepts

Overview of SAS software and its applications
Installing and setting up SAS environment
Understanding SAS windows: Editor, Log, Output
Basic syntax: SAS statements, data steps, and procedures
Importing and exporting data (Excel, CSV, and text files)
Running and debugging simple SAS programs

Data Manipulation and Cleaning

Understanding SAS datasets: Data types, variables, and observations
Creating and modifying datasets using DATA step
Conditional processing with IF-THEN-ELSE statements
Handling missing values and data validation
Using SET, MERGE, and UPDATE statements
Sorting, filtering, and subsetting data

Working with SAS Functions

Character functions (UPCASE, LOWCASE, TRIM, SCAN, etc.)
Numeric functions (ROUND, INT, SUM, MEAN, etc.)
Date and time functions (DATEPART, YEAR, MONTH, TODAY, etc.)
Creating new variables using functions
Applying functions in data manipulation

Data Aggregation and Reporting

Introduction to PROC SQL (SQL in SAS)
Creating summary reports using PROC MEANS, PROC FREQ, and PROC SUMMARY
Generating tables and reports with PROC REPORT and PROC TABULATE
Formatting output using ODS (Output Delivery System)
Grouping and summarizing data

Data Merging, Joins, and Advanced Data Handling

Merging datasets using MERGE and PROC SQL JOIN
One-to-one and one-to-many merges
Using PROC TRANSPOSE for reshaping data
Advanced data handling techniques
Understanding data-driven programming with CALL SYMPUT and SYMPUTX

SAS Macros for Automation

Introduction to SAS Macros and benefits
Defining and calling macros
Using macro variables and parameters
Conditional processing in macros
Writing efficient and reusable macros
Debugging and troubleshooting macros

Introduction to SAS Administration

Overview of SAS Viya Architecture

Understanding SAS Viya vs. SAS 9.x
Key components of SAS Viya
SAS Cloud Analytic Services (CAS)
SAS Compute Server
SAS Viya Infrastructure Servers
Web Applications and Services
Deployment options: On-premises, Cloud (AWS, Azure, GCP), and Hybrid

Final Project & Certification

Review of key concepts and best practices
Hands-on final project (real-world data problem)
Presenting SAS reports and insights
Common pitfalls and performance optimization
Q&A and discussion
Course completion certification

Coach: Dennis Collins

Worked as Senior Vice President/General Manager of 3 major Miami radio stations, supervised over 150 people, generated up to $35 Million in annual revenue with a 63% net operating profit margin.

Running a weekly podcast “Connect and Convert”, sharing all the latest and greatest information for small business owners about how to accelerate their sales faster than ever.

Certified Social Styles and Versatility Facilitator
Certified Adaptive Mindset and Resilience Facilitator
Founding Member, Certified Influence Coach, The Cialdini Institute
Wharton School: University of Pennsylvania: Certificate: Understanding the Brain: Using Neuroscience to Deliver Better Business Results

Let’s Get Started

Master the power of data with SAS! Become a Subject Matter Expert and lead the way in analytics, business intelligence, and data-driven decision-making.