This online course is delivered using a blended learning pathway via our digital learning platform and builds on the learnings provided in the Fundamentals course, providing learners with an immediately useful armoury of new statements and functions.
There are mini quizzes and comprehensive exercises throughout to help assess and reinforce your learning with the opportunity to join an end of day Q&A session(s) with the instructor.
By the end of this course you will be able to:
On day 1 we invite you to join a short online welcome to meet your instructor, introduce you to our Digital Learning platform and get you started on the eLearning modules of this course.
You will need 2.5 hours to complete the 3 eLearning modules with additional time for exercises. We ask you to complete these modules before joining us for an online Masterclass in the afternoon of day 1.
This is followed by 2 x 4 hour live online classes to complete your learning.
In addition, you will also need to set aside time to complete the Hands-On exercises.
Each day finishes with an open Q&A session with the instructor if you need any further support.
What you should already know...
To get the most out of this course, it is expected that you should have attended the Fundamentals - the Language of SAS course (or comparable course of study). If not, we would advise that you have completed six months of developing code in the language of SAS, including:
- Building DATA and PROC steps
- Character, Numeric and Date functions
- KEEP and DROP to select variables
- IF and WHERE statements to select observations
- Conditional Processing with IF-THEN-ELSE
- Combining Data Sets vertically and horizontally
- Summarising data with the FREQ, MEANS and TABULATE procedures
For the hands-on practice activities in the course, you will need access to an environment that runs the programming Language of SAS. On our courses, we signpost you to some of the free tools available.
Check out the options below to review system requirements:
What you'll be taught...
Character Functions (eLearning)
Learning Objective: Describe how functions are used to perform character transformation including:
- SUBSTR, SCAN, TRIM, COMPRESS, LEFT, RIGHT, CATX, INDEX, FIND, UPCASE, LOWCASE, PROPCASE and TRANWRD
Numeric Functions (eLearning)
Learning Objective: Describe how functions are used to perform numeric transformation including:
- SUM, MEAN, MIN, MAX, ROUND, CEIL, FLOOR, INT
Date Functions (eLearning)
Learning Objective: Describe how functions are used to perform date transformation including:
- TODAY, DATE, MDY, DAY, MONTH,YEAR, WEEKDAY, QTR, TIME / DATETIME, TIMEPART / DATEPART, INTCK / INTNX, YRDIF / DATDIF
Changing Data Types using Functions (Live Online Class)
Learning Objective: Describe how functions are used to change variable type
- Automatic character to numeric conversion
- INPUT Function to convert character values to numeric
- Automatic numeric to character conversion
- PUT Function to convert numeric values to character
Summarising Observations and Variables (Live Online Class)
Learning Objective: Describe how to use the Data Step to summarise variables and observations using:
- RETAIN statement
- SUM Statement
- BY-Group processing
Iterative Processing (Live Online Class)
Learning Objective: Describe how to iterative and conditional loops to iterate multiple times within a Data Step and manipulate your dataset structures:
- Create and execute DO Loops
- Conditional processing with DO UNTIL and DO WHILE
- Combine Iterative and Conditional DO Loops
Array Processing (Live Online Class)
Learning Objective: Describe how to use arrays within a Data Step to temporarily link variables across observation
- Define an Array
- Use Array References
- Using Arrays with DO loops, to perform repetitive actions and to store temporary and existing variables
Transposing Data (Live Online Class)
Learning Objective: Describe how to use a Data Step and the Transpose procedure to transpose data tables:
- Using Conditional Logic in a DATA Step
- Using PROC TRANSPOSE
- User Defined Formats with PROC FORMAT (Live Online Class)
- Learning Objective: Describe how to use the Format procedure to create and save user-specific formats for use:
- Apply formats to your data
- Create your own formats and apply them to your data
- Create a format with data from a dataset
Output Delivery System (Live Online Class)
Learning Objective: Describe the Output Delivery System (ODS) and some of the ODS destinations
- The Output Delivery System (ODS)
- Control output to ODS destinations
- Create Datasets from Procedures