This course includes:
- 3.5 hours on-demand video
- Full lifetime access
- Access on mobile devices
-
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.
Base course
Learn the course content at your own pace. If you have questions or curiosities, you may want to pay just a little more and have the possibility to interact directly with the expert trainer.
Have a look at the course with the "Expert Support Available" tag.
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 complete FREE !
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 watching the course, you'll earn a Certificate that you can share with prospective employers and your professional network.
Course Curriculum
- 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)
- 13. Macro Functions (3:30)
- 14. Macro Functions-Code (8:41)
- 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)
- 18. Conditional Logic in Macros using IF-ELSE (10:49)
- 19. Options Statement - MPRINT - MLOGIC - SYMBOLGEN (12:45)
- 20. Connecting the Two Worlds - Call Symput and Symget (13:56)
- QUIZ 1 - Macros
- 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
- 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. 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
- QUIZ 2 - Proc SQL Quiz
Featured Products
Have a look at these other wonderful courses!
