The Simplest Guide™ to Advanced SAS Programming | Macros | Proc SQL

For over 20 years, SAS has been the programming language of choice in many industries such as pharma, finance, and insurance, thanks to its ability to handle large amounts of data and its powerful analytics and visualization capabilities. As powerful as SAS programming is, it is also incredibly accessible.

This course is designed to strengthen your existing knowledge of SAS so that you can use SAS procedures to reveal amazing insights within your data. While the course is an accelerated path to learning advanced SAS programming designed for advanced users, its visual and immersive style of delivery will help you not just comprehend the concepts easier and faster but retain them as well.

The first section of the course teaches you how to build powerful code using SAS Macros. That way, you can significantly reduce your coding lines to make your code reusable and efficient. The second section will teach you how to combine the power of SAS and SQL in one procedure called PROC SQL. You will use SAS OnDemand, which is free to download and install on a PC or Mac.

By the end of this course, you will be able to build complex SAS programming code using macros, write powerful SQL queries in SAS to extract, analyze, and visualize data, and prepare for advanced SAS certification exams.

What You Will Learn

• Install SAS through SAS OnDemand
• Build powerful, complex SAS programming code using macros
• Use SAS macros to reduce your coding lines to make it reusable, and efficient
• Leverage the power of SAS and SQL together in a single procedure
• Build SQL queries in SAS to extract, analyze, and visualize data
• Prepare for advanced SAS certification exams

Audience

vIf you want to strengthen your foundation of SAS programming and learn advanced SAS, then this course is for you. In order to learn from this course, you should have basic knowledge of SAS programming.

The course will also benefit to ones who want to pass the advanced SAS certification.

About The Author

Aslam Khan: Aslam Khan works with businesses in understanding their complex problems, surfacing their business needs and offering viable technical solutions, overseeing change management, program benefits realization, and organizational project management. He has also worked in the clinical data management, biostatistics, and SAS programming areas of the life sciences industry.

He is a certified Project Management Professional (PMP) and a SAS Base and Advanced Certified Programmer, with a master’s degree in management information systems.