Self-Paced Courses

Macro Programming
15 hours
Self-Paced
£155 + VAT
This eLearning pathway will provide you with the knowledge, tools and techniques to enhance your code and which you can apply in a wide range of settings to make your programs smarter. Learn how to wr…
Read More
Manipulating Data Using Functions
2 hours
Self-Paced
£75 + VAT
This  self-paced eLearning pathway will provide you with the knowledge, tools and techniques to manipulate and transform data using character, numeric and date functions. There are mini quizzes and c…
Read More
Introduction to Macros
2.5 hours
Self-Paced
£75 + VAT
This self-paced eLearning pathway will provide you with the knowledge, tools and techniques to enhance your code and which you can apply in a wide range of settings to make your programs smarter. Lear…
Read More
Introduction to PROC SQL
2 hours
Self-Paced
£75 + VAT
This self-paced eLearning pathway will give you an introduction into the use of PROC SQL in the language of SAS. There are mini quizzes and comprehensive exercises throughout to help assess and reinfo…
Read More
Summarise Data using PROC SQL
30 minutes
Self-Paced
£25 + VAT
In this eLearning module you will learn how to  Produce Summary Statistics Create Columns by a query Classify Data – GROUP BY Summarise Statistics by Group Select Summarised Data – HAVING There …
Read More
Selecting Rows and Columns in PROC SQL
35 minutes
Self-Paced
£25 + VAT
In this eLearning module you will learn how to: Select Columns The DESCRIBE and FEEDBACK options Create Columns The CASE Expression Select Rows Special WHERE Operators CALCULATED Rows There are mini…
Read More
Macro Variables
45 minutes
Self-Paced
£25 + VAT
In this eLearning module you will learn how Macro Functions can be used for character manipulation and numeric calculations. In this module you will learn different features of Macro Variables includi…
Read More
Numeric Functions
30 minutes
Self-Paced
£25 + VAT
In this eLearning module you will learn how to transform numeric data using a variety of useful functions including: SUM, MEAN, MIN, MAX, ROUND, CEIL, FLOOR, INT Each function is introduced in s…
Read More
Macro Processing
35 minutes
Self-Paced
£25 + VAT
In this eLearning module you will learn key Macro Processing concepts including: Compilation and Execution phases Tokenization Macro Triggers The %PUT Statement Displaying macro variable values There …
Read More
Macro Functions
40 minutes
Self-Paced
£25 + VAT
In this eLearning module you will learn how Macro Functions can be used for character manipulation and numeric calculations. You will review Data Step functions and learn how to use these in a Macro c…
Read More
Introduction to SQL Language Elements
25 minutes
Self-Paced
£25 + VAT
In this module you will learn: Origins of Structured Query Language (SQL) Implementing SQL within the Language of SAS SQL Language Elements There are also mini quizzes throughout to help assess and r…
Read More
Date Functions
45 minutes
Self-Paced
£25 + VAT
In this eLearning module you will learn how to transform date values using a variety of useful date functions, including: TODAY, DATE, MDY, DAY, MONTH, YEAR, WEEKDAY, QTR, TIME / DATETIME, TIME…
Read More
Character Functions
45 minutes
Self-Paced
£25 + VAT
In this eLearning module you will learn how to transform character data using a variety of useful functions including: SUBSTR, SCAN, TRIM, COMPRESS, LEFT, RIGHT, CATX, INDEX, FIND, UPCASE, LOWCASE, PR…
Read More