• LOGIN
  • No products in the cart.

Login

Level
Advanced

Units
93
Duration
15.21 Hours

GET LIFETIME ACCESS TO THIS COURSE AND 2500+ OTHER COURSES FOR ONLY £99. FIND OUT MORE

  • 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

Unit - 1
Section 0-00- Why SAS 00:01:00
Section 0-01- Course Overview 00:02:00
Unit - 2
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
Unit - 3
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
Unit - 4
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
Unit - 5
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
Unit - 6
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
Resources – SAS Programming Basic to Advanced 00:00:00

Don't just take our word for it

Select your currency