Advanced SAS Programming Using MacrosSQL

One Education

Reed Courses Certificate of Completion

Digital certificate - Included

• Advanced SAS Programming Using MacrosSQL 4:10:17

  • 1: Section 0-00- Why SAS 01:28
  • 2: Section 2-02- SAS Studio through SAS OnDemand- Registration 03:31
  • 3: Section 2-02- SAS University Edition - download and install 10:21
  • 4: Section 2-03- Logging-in to SAS after installation 00:54
  • 5: Section 2-04- SAS Interface and windows 05:59
  • 6: Section 3-00- Section Overview - Macros 00:06
  • 7: Section 3-01-Macro Variables - introduction 14:06
  • 8: Section 3-02-Application of macro variables 12:35
  • 9: Section 3-03-01-Nested macro vars 10:56
  • 10: Section 3-03-02-More on Ampersand resolutions using a cool example 09:04
  • 11: Section 3-04-00-SAS Macros - introduction 10:10
  • 12: Section 3-04-01-SAS Macros - Examples 07:11
  • 13: Section 3-04-02-Keyword positional and mixed params 06:05
  • 14: Section 3-04-03-Conditional Logic in Macros 10:49
  • 15: Section 3-05-Macro Functions 12:11
  • 16: Section 3-05-Options Statement- mprint-mlogic-symbolgen 12:45
  • 17: Section 3-07-Connecting the two worlds - Call Symput - Symget 13:56
  • 18: Section 3-09-01-02- Bringing data into SAS using Import Wizard 03:45
  • 19: Section 3-09-02- Bringing data into SAS using LIBNAME statement 05:14
  • 20: Section 3-09-03- Bringing data into SAS using FILENAME 05:07
  • 21: Section 4-00- Section Overview - Proc SQL 00:06
  • 22: Section 4-01-01-Proc SQL - copying data 13:15
  • 23: Section 4-01-02-Proc SQL - filtering data 06:54
  • 24: Section 4-01-03-Proc SQL - sorting data 08:27
  • 25: Section 4-01-04-Proc SQL - removing duplicates 05:26
  • 26: Section 4-02-01-Proc SQL - Union 08:33
  • 27: Section 4-02-02-Proc SQL - Except 04:27
  • 28: Section 4-02-03-Proc SQL - Intersect 01:39
  • 29: Section 4-03-00-Merging data using Joins-Introduction 07:41
  • 30: Section 4-03-01-Proc SQL - inner join 14:18
  • 31: Section 4-03-02-Proc SQL - full join 07:42
  • 32: Section 4-03-03-Proc SQL - left and right joins 06:52
  • 33: Section 4-04-01-Proc SQL - creating macro vars 06:48
  • 34: Section 5-00- Bonus lecture 01:56

• Leave a Review 01:00

  • 35: Leave a Review 01:00

This Advanced SAS Programming Using MacrosSQL course is designed for learners who already have a foundational understanding of SAS and want to level up their skills. The course provides a deep dive into macro programming, automation, and SQL-based data manipulation. It offers practical, hands-on lessons that reflect real-world data analysis scenarios.

With expert-led content and clear examples, you’ll learn how to write efficient SAS code, automate processes with macro functions, and use PROC SQL to manage and manipulate large datasets. Perfect for professionals in the data analytics space, this course combines theoretical knowledge with practical application.

Learning Objectives:

• Understand and apply macro variables and functions in SAS
• Automate tasks using advanced macro techniques
• Import and manage data using LIBNAME, FILENAME, and the Import Wizard
• Perform advanced queries using PROC SQL, including joins and set operators
• Create macro variables dynamically using SQL procedures

Why Should You Take This Course?

Whether you're aiming to transition into a more technical analytics role or looking to enhance your current position, this course gives you the advanced tools needed to excel. With growing demand for automation and data-driven strategies, SAS professionals with macro and SQL expertise are increasingly sought after. This course not only enhances your skillset but positions you for long-term career growth in a high-demand field.

Course Curriculum:

• Module 01: Introduction to SAS & Setup

Covers the basics of SAS, its significance in data analysis, and how to access and navigate the SAS environment using SAS Studio and OnDemand.

• Module 02: Working with SAS Interface & Environment

Introduces the SAS interface, explaining the key windows and components required to interact effectively with SAS tools and datasets.

• Module 03: Advanced Macro Programming in SAS

Explores macro variables, macro functions, conditional logic, and techniques to automate repetitive coding tasks, along with integrating macro functionality into practical SAS workflows.

• Module 04: Data Manipulation Using PROC SQL

Focuses on using PROC SQL for advanced data manipulation—covering data filtering, joins, unions, and creating macro variables directly through SQL procedures.

• Module 05: Bonus Content & Final Assignment

Includes additional tips, use-case examples, and a final assignment to apply the learned concepts in a real-world scenario.

• Aspiring data analysts and data scientists
• SAS users seeking to automate their workflows
• Professionals in healthcare, finance, or insurance
• Anyone preparing for advanced SAS certifications
  
  

• No prior experience required
• Just an internet connection, a compatible device, and willingness to learn

• SAS Programmer – £45k to £70k
• Data Analyst – £40k to £65k
• Data Scientist – £50k to £80k
• Business Intelligence Analyst – £45k to £70k
• Statistical Programmer – £50k to £75k

Currently there are no Q&As for this course. Be the first to ask a question.