The Simplest Guide™ to Advanced SAS Programming | Macros | Proc SQL
Video description
A simple guide to advanced SAS programming to help you master data analysis and prepare for advanced SAS certification exams.
About This Video
Learn how to use powerful SAS procedures that reveal amazing insights within your data
Extract, analyze, and visualize data by building powerful SQL queries in SAS
Prepare for advanced SAS certification exams
In Detail
For over 20 years, SAS has been the programming …
The Simplest Guide™ to Advanced SAS Programming | Macros | Proc SQL
Video description
A simple guide to advanced SAS programming to help you master data analysis and prepare for advanced SAS certification exams.
About This Video
Learn how to use powerful SAS procedures that reveal amazing insights within your data
Extract, analyze, and visualize data by building powerful SQL queries in SAS
Prepare for advanced SAS certification exams
In Detail
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.
Who this book is for
If 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.
SAS Studio through SAS OnDemand: Download and Install
Logging into SAS
SAS interface and Windows
Chapter 3 : SAS macros
Section Overview - Macros
Macro Variables - Introduction
Macro Variables - Introduction: Code
Application of Macro Variables
Application of Macro Variables - Code
Nested Macro Variables
More on Ampersand Resolution
Macro Functions
Macro Functions - Code
SAS Macros - Introduction
SAS Macros Examples
Keyword and Positional Parameters
Conditional Logic in Macros Using IF-ELSE
Options Statement - MPRINT-MLOGIC-SYMBOLGEN
Connecting the Two Worlds - Call Symput and Symget
Chapter 4 : Proc SQL
Section Overview - Proc SQL
Copying Data
Filtering Data
Sorting Data
Removing Duplicates
Union Set Operator
Except Set Operator
Intersect Set Operator
Merging Data Using Joins
Inner Join
Full Join
Left and Right Joins
Creating Macro Variables from Proc SQL
Start your Free Trial Self paced Go to the Course We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.
This site uses cookies. By continuing to use this website, you agree to their use.I Accept