SAS Programming Basic to Advanced

SAS Programming Basic to Advanced



The SAS Programming Basic to Advanced is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain an accredited certificate after completing the course. Enrol now for a limited-time discounted price.

Like all the courses of One Education, this SAS Programming Basic to Advanced is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily.

We don’t just provide courses at One Education; we provide a rich learning experience. After purchasing a course from One Education, you get complete 1-year access with tutor support. 

Our expert instructors are always available to answer all your questions and make your learning experience exquisite.

After completing the SAS Programming Basic to Advanced, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV.

If you want to learn about this topic and achieve certifications, you should consider this SAS Programming Basic to Advanced from One Education.

There are no hidden fees or exam charges. We are very upfront and clear about all the costs of the course. 

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hard Copy Certificate for £15.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The SAS Programming Basic to Advanced is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

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 – SAS Programming Basic to Advanced 00:00:00



COPYRIGHT © 2021 One Education