The Simplest Guide to Advanced SAS Programming -Macros-SQL

Name: The Simplest Guide to Advanced SAS Programming -Macros-SQL
Rating: 4.5 (230 reviews)

Master Data Analysis using advanced SAS skills like SAS Macros & Proc SQL | SAS Advanced Certification | SAS Base Prereq

Created byAslam Khan

Last updated 4/2023

English

English [Auto],

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

Course content

4 sections • 32 lectures • 3h 39m total length

SAS Studio through SAS OnDemand - Registration3:31
SAS Studio through SAS Ondemand is offered for FREE. This has replaced SAS University Edition from May 1 2021 onwards. Follow the instructions in this video to see how you can start using SAS Studio with no installation necessary.
Logging-in to SAS0:42
Log in to SaaS by launching Oracle VM VirtualBox, starting the SaaS session, then open http://localhost:10080 to reach the welcome screen and start SaaS studio.
SAS Interface and Windows6:00

Section Overview - Macros0:06
Macro Variables - Introduction10:23
Discover the SAS macro world, where everything is text, contrast macro variables and macros with data world concepts, and use ampersand and %let to create and call macro values.
Macro Variables - Intro - code3:43
Application of Macro Variables1:29
Learn how macro variables, stored and processed in the macro world, interact with the data world to reduce redundancies and repetition in SAS programming.
Application of Macro Variables - code11:05
Nested Macro Vars10:56
Explore nested macro variables in SAS by using consecutive ampersands and the three resolution rules to retrieve inner values, from left to right.
More on Ampersand resolution9:04
Ampersand Resolution Assignment
Macro Functions3:30
Discover how macro functions operate on macro variables, how macros interact with the data world, and syntax using a leading percent sign, with an example converting United States to uppercase.
Macro Functions - code8:41
Learn to apply macro functions to macro variables in SAS, including upcase and lowercase for casing, substring and length for extraction, and eval or evalf for numeric calculations.
Using macro variables in data step and proc step
SAS Macros - Introduction10:10
SAS Macros Examples7:11
Keyword and positional parameters6:05
Parameters in Macros
Conditional Logic in Macros using IF-ELSE10:49
Explore conditional logic in SAS macros using if-else to drive macro variables and generate dynamic analysis paths, switching between proc means and the frequency procedure based on input parameters.
Reusing Macros to do more
Options Statement - MPRINT - MLOGIC - SYMBOLGEN12:45
Debug SAS macros with imprint, mlogic, and symbolgen to see the final code generated by the macro and its means or related procedure outputs.
Connecting the two worlds - Call Symput and Symget13:56
Learn to connect the macro and data worlds by using call symput and symget to transfer values between datasets and macro variables, including sorting and data step examples.
Macro for Charts
Macros
Macros

Section Overview - Proc SQL0:06
Explore the Proc SQL section in the macros-sql SAS guide, outlining how to use Proc SQL within advanced SAS programming.
Copying data8:55
Filtering data6:54
Sorting data8:27
This lecture shows sorting data in sas using proc sort and proc sql, creating an output table and sorting by multiple variables with default ascending order.
Removing Duplicates5:26
Remove exact duplicate observations with proc sql by using select distinct from a data set across all variables, and let the distinct keyword mirror the proxy no-dupe option.
Analyzing the cars data
Union Set Operator8:33
Except Set Operator4:28
Learn how the except set operator subtracts common observations from the union of datasets A and B, returning only A-exclusive records, with an optional all to preserve duplicates.
Intersect Set Operator1:39
Explore the intersect set operator in SAS SQL, returning only observations common to both data sets A and B. When observations differ, no results appear.
Merging Data Using Joins7:48
Merge data from multiple data sets into a single, unified data set using joins and a common variable. Explore inner and outer joins to enable rapid analytics.
Inner Join14:18
Full Join7:42
Left and Right Joins6:52
Learn how to perform outer left and right joins in SAS using proxy equal within a data step, merging datasets to align name and height variables.
Creating Macro Variables from Proc SQL6:48
Macro vars from Proc SQL
Proc SQL Quiz
Proc SQL

Requirements

SAS Base knowledge is recommended
Internet connectivity to download and work in SAS University Edition

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 SAS9
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 !
Quiz and Practice Tests included

COURSE SECTIONS

SAS Macros will teach you how to build powerful code using the power of SAS Macros, how to significantly reduce your coding lines to make your code reusable, efficient and do a lot more.
PROC SQL will teach you how to combine the power of SAS and SQL together in one procedure called PROC SQL (more lectures are planned to be added soon)

Earn a Certificate

When you finish listening to all videos, assignments, quizzes and practice exams, you'll earn a Certificate that you can share with prospective employers and your professional network.

Who this course is for:

Want 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

The Simplest Guide to Advanced SAS Programming -Macros-SQL

What you'll learn

Explore related topics

Course content

Installing SAS3 lectures • 10min

SAS Macros15 lectures • 2hr

Proc SQL13 lectures • 1hr 28min

Final Assignment1 lecture • 2min

Requirements

Description

Who this course is for: