Course Overview

This 10 hour course is intended to cover all fundamental skills and knowledge on basic SAS programming, including accessing, managing, summarizing, and analyzing data from different sources, and visualizing results in presentable formatting. You will gain hands-on experience on using SAS Studio, writing SAS queries, exploring and validating data. Financial industry data will be used in practical projects and case studies. After the training, students will be enabled with fundamental SAS skills to pursue any analytical positions that require intermediate SAS programming skills.

Each session has a duration of 2 hours.

Session 1 – SAS Overview

• Introduction of SAS Programming interfaces – SAS Studio

• SAS Syntax

• SAS Data Overview

• Accessing Data using SAS

Session 2 – Data Preparation

• Data Step Processing

• Computing New Columns

• Common Numeric Functions for creating columns

• Common Character Functions for creating columns

• Common Date Functions for creating columns

• Conditional Processing

Session 3 – Analyzing and Reporting on Data

• Common Procedures of analyzing data

• Macro Variables and Functions

• Exporting data to Excel

• Connecting to database

Session 4 – Using SQL in SAS

• Basic SQL syntax

• Common functions with SQL

• Joining tables using SQL in SAS

Session 5 – Projects & Interviews

• Apply the knowledge from prior session to build Hands-on analytics projects using SAS

• Common interview questions and tips will be discussed

Course Highlights

Being practical is the main highlight of this course! In just 10 hours of time, you will learn all fundamental knowledge of SAS programing, and get professional illustration on the daily work life of the data analytics industry with real life cases, which will serve as a valuable project experience both for preparation of interview and first month at work as well as a highlight on your resume.

Qualifications

This course is suitable for all levels of students and new graduates who are interested in data analytics and SAS programming. No previous experience or knowledge of SAS is required, and this course is highly recommended for students with analytical background such as statistics, mathematics, economics, engineering, finance etc. This course is also designed for people who are currently seeking for a career transformation into business data analytics areas, or interested in taking SAS BASE certification exams.

Mentor Profile

Mentor for this course has been working in the analytical field using SAS and other programming languages in the Canadian banking industry for over 8 years, and have helped many students without any related experience gain their first offer in analytical positions. The course mentor is a SAS Base and Advanced Certified Programmer, with a Master Degree in Economics. Currently working in BMO on a senior role, with her abundant work experience and accumulated network from various financial institutions, our mentor would love to share with students her past and current experience as much as she can and aim to provide the best guidance to students to achieve your dream offer!