- 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.
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
Amazing workshop.
Very informative for the freshers like me. Learned a lot of things about digital marketing. I'm really thankful.
Aarini Sinha 
It was a great experience. The course was jampacked with excellent information. And when I needed help, Skill-up helped me with technical problems instantly. Fast feedback.
Varsha Sivamohan 
I am currently signed on to several courses with skill up. I have just finished my second one. The courses are informative and good for all types of learners. I recommend them.
Judith Taylor 
The support team was FANTASTIC!!! Very quick to respond and even though I was nervous as I am not good at tests, they made me feel comfortable.
I am very grateful for the support
Charlie Anderson 
Completed the Level 3 Mental Health Support Worker course, very good and highly recommend it.
Very good course, enjoyed it thoroughly and important in my line of work as a Support worker.
Parmjit Dosanjh 
I am pleased to have completed my online course in Mental Health First Aid with SkillUp. All the modules were detailed & comprehensive with review questions, which really helped me to grasp the information & prepared me well for the mock test & final exam.
Shan 