- Course Highlights
Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This SAS Programming Advanced Course has been specially designed to help learners gain a good command of SAS Programming, providing them with a solid foundation of knowledge to become a qualified professional.
Through this SAS Programming Advanced Course, you will gain both practical and theoretical understanding of SAS Programming that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.
Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.

- Learning outcome
- Get a deep understanding of the SAS Programming Advanced Course just in hours not years
- Familiar yourself with the recent development and updates of the relevant industry
- Know how to use your theoretical and practical knowledge to adapt in any working environment
- Get help from our expert tutors anytime you need
- Access to course contents that are designed and prepared by industry professionals
- Study at your convenient time and from wherever you want

- Requirements
- No formal qualifications required, anyone from any academic background can take this course.
- Access to any internet-enabled smart device.
- Why should I take this course?
- 11+ hours of on-demand video lectures and downloadable resources.
- Affordable premium-quality E-learning content, you can learn at your own pace.
- You will receive a completion certificate upon completing the course.
- Internationally recognized Accredited Qualification will boost up your resume.
- You will learn the researched and proven approach adopted by successful salespeople to transform their careers.
- You will be able to incorporate various practical sales techniques successfully and understand your customers better.
Course Curriculum
-
Section 0-00- Why SAS
00:01:00
-
Section 0-01- Course Overview
00:02:00
-
Section 2-01- Why is SAS so easy to learn
00:03:00
-
Section 2-02- SAS University Edition – download and install
00:10:00
-
Section 2-03- Logging-in to SAS after installation
00:01:00
-
Section 2-04- SAS Interface and windows
00:06:00
-
Section 3-00- Preparing Data – Section Overview
00:01:00
-
Section 3-01- SAS Datasets Variables and Obs
00:09:00
-
Section 3-02- SAS Libraries
00:05:00
-
Section 3-04- Lib Naming Conventions
00:05:00
-
Section 3-05- SAS Dataset naming conventions
00:04:00
-
Section 3-06- SAS Prog syntax
00:07:00
-
Section 3-07- Data and proc step
00:03:00
-
Section 3-08- Referencing data in sas
00:05:00
-
Section 3-09-01- Bringing data into SAS
00:16:00
-
Section 3-09-02- Bringing data into SAS using LIBNAME statement
00:05:00
-
Section 3-09-03- Bringing data into SAS using FILENAME
00:05:00
-
Section 3-09-04- Bringing data into SAS using DELIMITER option
00:03:00
-
Section 3-09-05- Bringing data into SAS using DSD option
00:08:00
-
Section 3-09-06- Bringing data into SAS using column input
00:04:00
-
Section 3-09-07- Bringing data into SAS using the col pointer
00:02:00
-
Section 3-09-08- Bringing data into SAS using the line pointer#
00:07:00
-
Section 3-09-09- Bringing data into SAS using the line slash
00:02:00
-
Section 3-09-10- Bringing data into SAS using the trailing
00:03:00
-
Section 3-09-11- Bringing data into SAS using the trailing
00:02:00
-
Section 3-09-12- Bringing data into SAS using Proc Import xls
00:07:00
-
Section 3-09-13- Bringing data into SAS using Proc Import txt
00:05:00
-
Section 3-10- Creating new vars
00:13:00
-
Section 3-10-1- Keep, Drop and Rename variables
00:03:00
-
Section 3-11-If-else conditional statements
00:16:00
-
Section 3-12- Filtering data
00:11:00
-
Section 3-13- Sas dates
00:07:00
-
Section 3-14-01- SAS functions 1
00:22:00
-
Section 3-14-02- SAS functions 2
00:17:00
-
Section 3-15-01-SAS Formats – Introduction
00:03:00
-
Section 3-15-02-SAS Format Statement
00:05:00
-
Section 3-15-03-Format Naming Convention
00:09:00
-
Section 3-15-03-Format using Put function
00:10:00
-
Section 3-16-02-Proc Format
00:17:00
-
Section 3-16-SAS Informats
00:14:00
-
Section 3-17-01-Program Data Vector- PDV
00:06:00
-
Section 3-17-02-PDV Implicit Output
00:15:00
-
Section 3-17-03-PDV Explicit Output
00:17:00
-
Section 3-18- Do Loops
00:04:00
-
Section 4-00- Structuring Data – Section Overview
00:01:00
-
Section 4-01-01-Stacking data using a data step
00:06:00
-
Section 4-01-02-Stacking data using PROC APPEND
00:15:00
-
Section 4-01-03-Interleaving data
00:09:00
-
Section 4-02 – Sorting data using PROC SORT
00:15:00
-
Section 4-03-01-Removing duplicates-NODUP option
00:11:00
-
Section 4-03-02-Removing duplicates-NODUPKEY option
00:11:00
-
Section 4-04-01-Simple merging of data
00:09:00
-
Section 4-04-02-Merging data using Joins-Introduction
00:08:00
-
Section 4-04-03-Merging data using joins-Inner Join
00:16:00
-
Section 4-04-04-Merging data using Joins-Full Join
00:07:00
-
Section 4-04-05-Merging data using Joins-Left Join
00:06:00
-
Section 4-04-06-Merging data using Joins-Right Join
00:04:00
-
Section 4-04-07-Merging data using Joins-Far Joins
00:06:00
-
Section 4-05-01-Proc SQL – copying data
00:13:00
-
Section 4-05-02-Proc SQL – filtering data
00:07:00
-
Section 4-05-03-Proc SQL – sorting data
00:08:00
-
Section 4-05-04-Proc SQL – removing duplicates
00:05:00
-
Section 4-06-01-Transposing data using ID statement
00:13:00
-
Section 4-06-02-Transposing data using BY statement
00:14:00
-
Section 4-07-01-Retain statement – introduction
00:07:00
-
Section 4-07-02-Retain statement – how it is used
00:06:00
-
Section 4-07-03-Retain statement – an example
00:08:00
-
Section 5-00- Visualizing Data – Section Overview
00:01:00
-
Section 5-01-01-Charts – vbar hbar pie
00:11:00
-
Section 5-01-02-Vertical Bar Chart – discrete option
00:10:00
-
Section 5-01-03-Horizontal Bar Chart – discrete option
00:02:00
-
Section 5-01-04-Vertical Bar Chart – groups and subgroups
00:11:00
-
Section 5-01-05-Horizontal Bar Chart – groups and subgroups
00:03:00
-
Section 5-02- Plots
00:05:00
-
Section 5-03-Report Output using PROC PRINT
00:06:00
-
Section 5-04-Report Output using PROC REPORT
00:13:00
-
Section 5-06-Summary stats – PROC FREQ
00:08:00
-
Section 5-06-Summary stats – PROC MEANS
00:03:00
-
Section 5-06-Summary stats – PROC UNIVARIATE
00:02:00
-
Section 5-07- Output Delivery System (ODS) – Reports
00:02:00
-
Section 5-07-01- ODS with PROC FREQ
00:04:00
-
Section 5-07-02- ODS with PROC MEANS
00:02:00
-
Section 5-07-03- ODS with PROC UNIVARIATE
00:04:00
-
Section 6-00- Optimizing Code – Section Overview
00:01:00
-
Section 6-01-Macro Variables – introduction
00:14:00
-
Section 6-02-Application of macro variables
00:13:00
-
Section 6-03-01-Nested macro vars
00:11:00
-
Section 6-03-02-More on Ampersand resolutions
00:09:00
-
Section 6-04-00-SAS Macros – introduction
00:10:00
-
Section 6-04-01-SAS Macros – Examples
00:07:00
-
Section 6-05-Macro Functions
00:12:00
-
Section 6-06-Bonus lecture
00:02:00
-
Resources – SAS Programming Basic to Advanced
Offer Ends in

-
Duration:11 hours, 31 minutes
-
Access:1 Year
-
Units:93

