This course includes:
- 3.5 hours on-demand video
- downloadable resources
- 2 practice tests
- Full lifetime access
- Access on mobile devices
- Assignments
-
Certificate of completion
Aslam Khan
Meet your expert trainer for this course!
A certified Program Management Professional (PgMP), Project Management Professional (PMP) and a SAS Base and Advanced Certified Programmer, with a Master's Degree in Management Information Systems, Alsam will guide you through the sometimes complex concepts by breaking them down using simple illustrations and easy to understand language. His very intuitive approach will ultimately help you understand, learn and retain the topics of interest.
Expert Support Available!!!
In this course you will be able to interact with the trainer for valuable help. The course contains video lessons, quizzes and assignments that may be tricky at times. Ask the expert trainer directly for support, suggestions, clarifications or even curiosities!
He will get back to you in a timely manner and you may trigger an interesting conversation.
What you'll learn
- Learn Advanced SAS in the most effective way through simple, visual and engaging lectures
- Analyze data with powerful SAS procedures that reveal amazing insights within your data
- Strengthen your foundation to appear for SAS Advanced certification exams
- Learn to build powerful SAS Macros
-
Learn to use the combined power of SAS and SQL in Proc SQL
Description
A comprehensive, simple and visual guide to SAS Programming, this course is simplified into the 2 main areas: SAS Macros and Proc SQL.
- This course is for advanced users who wish to do Data Analysis using advanced SAS Programming
- Delivered in a highly visual style, you will experience a unique and immersive method of the lectures
- Equips you with the cutting-edge tool used in many industries, primarily in Pharma, Finance and Insurance areas
- Simplified to just 2 main areas, this course is an accelerated path to learning advanced SAS programming
- A guide to the following SAS certification exams:
- SAS Certified Associate: Programming Fundamentals Using SAS 9.4 (Exam ID: A00-215)
- SAS Certified Specialist: Base Programming Using SAS 9.4 (Exam ID: A00-231)
- SAS Certified Professional: Advanced Programming Using SAS 9.4
- SAS Certified Clinical Trials Programmer Using SAS®9
- Super easy to to start using SAS with installation necessary. All you need is a web browser and a good internet connection. This course uses the latest SAS Studio offered by SAS OnDemand and is completely FREE !
-
Quiz and Practice Tests included
Requirements
- SAS Base knowledge is recommended
- Internet connectivity to download and work in SAS University Edition
Who this course is for:
Whoever wants to:
- Pass the Advanced SAS Certification
- Build complex SAS programming code using Macros
- Build powerful SQL queries in SAS to extract, analysis and visualize data
Earn a Certificate
When you finish listening to all the videos, do the assignments, take the quizzes and practice exams, you'll earn a Certificate that you can share with prospective employers and your professional network.
Course Curriculum
Section 1: Introduction
Available in
days
days
after you enroll
Section 2: Installing SAS
Available in
days
days
after you enroll
Section 3: SAS Macros
Available in
days
days
after you enroll
- 6. Section Overview - Macros (0:06)
- 7. Macro Variables - Introduction (10:23)
- 8. Macro Variables - Introduction - Code (3:43)
- 9. Application of Macro Variables (1:29)
- Resource - Application of Macro Variables
- 10. Application of Macro Variables-Code (11:05)
- 11. Nested Macro Vars (10:56)
- Resource - Nested Macro Vars
- 12. More on Ampersand and Resolutions (9:04)
- Resource - More on Ampersand and Resolutions
- Assignment 1: Ampersand Resoluton
- Assignment 1: Ampersand Resolution INSTRUCTOR EXAMPLE
- 13. Macro Functions (3:30)
- Resource - Macro Functions
- 14. Macro Functions-Code (8:41)
- Assignment 2: Using macro variables in data step and proc step
- Assignment 2: Using macro variables in data step and proc step INSTRUCTOR EXAMPLE
- 15. SAS Macros - Introduction (10:11)
- Resource - SAS Macros
- 16. SAS Macros - Examples (7:11)
- Resource - Macros Examples
- 17. Keyword Positional and Mixed Parameters (6:05)
- Assignment 3: Paramaters in Macros
- Assignment 3: Paramaters in Macros INSTRUCTOR EXAMPLE
- 18. Conditional Logic in Macros using IF-ELSE (10:49)
- Assignment 4: Reusing Macros to do more
- Assignment 4: Reusing Macros to do more INSTRUCTOR EXAMPLE
- 19. Options Statement - MPRINT - MLOGIC - SYMBOLGEN (12:45)
- 20. Connecting the Two Worlds - Call Symput and Symget (13:56)
- Assignment 5: Macro for Charts
- Assignment 5: Macro for Charts INSTRUCTOR EXAMPLE
- QUIZ 1 - Macros
- Practice Test 1 - Macros
Section 4: Proc SQL
Available in
days
days
after you enroll
- 21. Section Overview - Proc SQL (0:06)
- 22. Copying Data (13:15)
- Resource - Copying data
- 23. Filtering Data (6:54)
- Resource - Filtering data
- 24. Sorting Data (8:27)
- Resource - Sorting data
- 25. Removing Duplicates (5:27)
- Resource - Removing Duplicates
- Assignment 6: Analyzing the cars data
- Assignment 6: Analyzing the cars data INSTRUCTOR EXAMPLE
- 26. Union Set Operator (8:34)
- Resource - Union Set Operator
- 27. Except Set Operator (4:28)
- Resource - Except Set Operator
- 28. Intersect Set Operator (1:39)
- Resource - Intersect Set Operator
- 29. Merging Data Using Joins (7:42)
- 30. Inner Join (14:18)
- Resource - Inner Join
- 31. Full Join (7:42)
- Resource - Full Join
- 32. Outer Joins - Left and Right Joins (6:52)
- Resource - Left and Right Joins
- 33. Creating Macro Variables from Proc SQL (6:48)
- Resource - Creating Macro Variables from Proc SQL
- Assignment 7: Macro vars from proc SQL
- Assignment 7: Macro vars from proc SQL INSTRUCTOR EXAMPLE
- QUIZ 2 - Proc SQL Quiz
- Practice Test 2 - Proc SQL
Section 5: Final Assignment
Available in
days
days
after you enroll
Did you like this course?
Available in
days
days
after you enroll
