- 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 SAS00:01:00
-
Section 0-01- Course Overview00:02:00
-
Section 2-01- Why is SAS so easy to learn00:03:00
-
Section 2-02- SAS University Edition – download and install00:10:00
-
Section 2-03- Logging-in to SAS after installation00:01:00
-
Section 2-04- SAS Interface and windows00:06:00
-
Section 3-00- Preparing Data – Section Overview00:01:00
-
Section 3-01- SAS Datasets Variables and Obs00:09:00
-
Section 3-02- SAS Libraries00:05:00
-
Section 3-04- Lib Naming Conventions00:05:00
-
Section 3-05- SAS Dataset naming conventions00:04:00
-
Section 3-06- SAS Prog syntax00:07:00
-
Section 3-07- Data and proc step00:03:00
-
Section 3-08- Referencing data in sas00:05:00
-
Section 3-09-01- Bringing data into SAS00:16:00
-
Section 3-09-02- Bringing data into SAS using LIBNAME statement00:05:00
-
Section 3-09-03- Bringing data into SAS using FILENAME00:05:00
-
Section 3-09-04- Bringing data into SAS using DELIMITER option00:03:00
-
Section 3-09-05- Bringing data into SAS using DSD option00:08:00
-
Section 3-09-06- Bringing data into SAS using column input00:04:00
-
Section 3-09-07- Bringing data into SAS using the col pointer00: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 slash00:02:00
-
Section 3-09-10- Bringing data into SAS using the trailing00:03:00
-
Section 3-09-11- Bringing data into SAS using the trailing00:02:00
-
Section 3-09-12- Bringing data into SAS using Proc Import xls00:07:00
-
Section 3-09-13- Bringing data into SAS using Proc Import txt00:05:00
-
Section 3-10- Creating new vars00:13:00
-
Section 3-10-1- Keep, Drop and Rename variables00:03:00
-
Section 3-11-If-else conditional statements00:16:00
-
Section 3-12- Filtering data00:11:00
-
Section 3-13- Sas dates00:07:00
-
Section 3-14-01- SAS functions 100:22:00
-
Section 3-14-02- SAS functions 200:17:00
-
Section 3-15-01-SAS Formats – Introduction00:03:00
-
Section 3-15-02-SAS Format Statement00:05:00
-
Section 3-15-03-Format Naming Convention00:09:00
-
Section 3-15-03-Format using Put function00:10:00
-
Section 3-16-02-Proc Format00:17:00
-
Section 3-16-SAS Informats00:14:00
-
Section 3-17-01-Program Data Vector- PDV00:06:00
-
Section 3-17-02-PDV Implicit Output00:15:00
-
Section 3-17-03-PDV Explicit Output00:17:00
-
Section 3-18- Do Loops00:04:00
-
Section 4-00- Structuring Data – Section Overview00:01:00
-
Section 4-01-01-Stacking data using a data step00:06:00
-
Section 4-01-02-Stacking data using PROC APPEND00:15:00
-
Section 4-01-03-Interleaving data00:09:00
-
Section 4-02 – Sorting data using PROC SORT00:15:00
-
Section 4-03-01-Removing duplicates-NODUP option00:11:00
-
Section 4-03-02-Removing duplicates-NODUPKEY option00:11:00
-
Section 4-04-01-Simple merging of data00:09:00
-
Section 4-04-02-Merging data using Joins-Introduction00:08:00
-
Section 4-04-03-Merging data using joins-Inner Join00:16:00
-
Section 4-04-04-Merging data using Joins-Full Join00:07:00
-
Section 4-04-05-Merging data using Joins-Left Join00:06:00
-
Section 4-04-06-Merging data using Joins-Right Join00:04:00
-
Section 4-04-07-Merging data using Joins-Far Joins00:06:00
-
Section 4-05-01-Proc SQL – copying data00:13:00
-
Section 4-05-02-Proc SQL – filtering data00:07:00
-
Section 4-05-03-Proc SQL – sorting data00:08:00
-
Section 4-05-04-Proc SQL – removing duplicates00:05:00
-
Section 4-06-01-Transposing data using ID statement00:13:00
-
Section 4-06-02-Transposing data using BY statement00:14:00
-
Section 4-07-01-Retain statement – introduction00:07:00
-
Section 4-07-02-Retain statement – how it is used00:06:00
-
Section 4-07-03-Retain statement – an example00:08:00
-
Section 5-00- Visualizing Data – Section Overview00:01:00
-
Section 5-01-01-Charts – vbar hbar pie00:11:00
-
Section 5-01-02-Vertical Bar Chart – discrete option00:10:00
-
Section 5-01-03-Horizontal Bar Chart – discrete option00:02:00
-
Section 5-01-04-Vertical Bar Chart – groups and subgroups00:11:00
-
Section 5-01-05-Horizontal Bar Chart – groups and subgroups00:03:00
-
Section 5-02- Plots00:05:00
-
Section 5-03-Report Output using PROC PRINT00:06:00
-
Section 5-04-Report Output using PROC REPORT00:13:00
-
Section 5-06-Summary stats – PROC FREQ00:08:00
-
Section 5-06-Summary stats – PROC MEANS00:03:00
-
Section 5-06-Summary stats – PROC UNIVARIATE00:02:00
-
Section 5-07- Output Delivery System (ODS) – Reports00:02:00
-
Section 5-07-01- ODS with PROC FREQ00:04:00
-
Section 5-07-02- ODS with PROC MEANS00:02:00
-
Section 5-07-03- ODS with PROC UNIVARIATE00:04:00
-
Section 6-00- Optimizing Code – Section Overview00:01:00
-
Section 6-01-Macro Variables – introduction00:14:00
-
Section 6-02-Application of macro variables00:13:00
-
Section 6-03-01-Nested macro vars00:11:00
-
Section 6-03-02-More on Ampersand resolutions00:09:00
-
Section 6-04-00-SAS Macros – introduction00:10:00
-
Section 6-04-01-SAS Macros – Examples00:07:00
-
Section 6-05-Macro Functions00:12:00
-
Section 6-06-Bonus lecture00:02:00
-
Resources – SAS Programming Basic to Advanced
14-Day Money-Back Guarantee
-
Duration:11 hours, 31 minutes
-
Access:1 Year
-
Units:93
Want to get everything for £149
Take Lifetime Pack