Course Highlights
Master the skills of advanced SAS programming. This SAS course will enrich your knowledge of Advanced SAS Programming Using MacrosSQL. It will explain how to use the SAS programming language and introduce you to its advanced features.
This course teaches you the advantages of using SAS programming. The course will teach you how to create an account for SAS OnDemand and log in to SAS after installation. Again, you’ll learn about the different components of the SAS user interface. You’ll understand the concept of MacrosSQLand find a comprehensive guide to applying macro variables. The course will teach you how to create and use SAS macros with examples. You’ll also identify the usage of nested macros variables.
Furthermore, you’ll find lessons on keyword positional and mixed parameters, how to use parameters within the macro facility, conditional logic using SAS Macros, and valuable information about PROC SQL. The SAS course will explain how to run SQL statements within a SAS program in PROC SQL. Enrol today!
Learning outcome
- Proficiency with the macros and UI of SAS Studio
- Sophisticated knowledge of functions and macro variables
- Capacity to Use Conditional Logic in SAS Programming
- Proficiency in utilising cutting-edge methods to integrate data sources
- Improved proficiency with data optimisation and manipulation
- Learn SQL so you can query and analyse data
- Ability to effectively optimise workflows for data processing
Course media
Why should I take this course?
- Find more sophisticated SAS features.
- Improve your SQL and macro data processing abilities.
- Obtain expertise in streamlining data workflows.
- Boost your analytical skills to make better judgements.
- Remain ahead of the competition in the data analytics area.
Career Path
- Data Analyst
- Business Intelligence Developer
- SAS Programmer
- Data Scientist
- Analytics Consultant
- Database Administrator
- Statistical Analyst
Requirements
- Basic understanding of SAS Programming
- Familiarity with data manipulation techniques
- Access to a computer or digital device with internet connectivity.
Course Curriculum
-
Section 0-00- Why SAS
00:01:00
-
Section 2-02- SAS Studio through SAS OnDemand- Registration
00:04:00
-
Section 2-03- Logging-in to SAS after installation
00:01:00
-
Section 2-04- SAS Interface and windows
00:06:00
-
Section 3-00- Section Overview – Macros
00:01:00
-
Section 3-01-Macro Variables – introduction
00:14:00
-
Section 3-02-Application of macro variables
00:13:00
-
Section 3-03-01-Nested macro vars
00:11:00
-
Section 3-03-02-More on Ampersand resolutions using a cool example
00:09:00
-
Section 3-04-00-SAS Macros – introduction
00:10:00
-
Section 3-04-01-SAS Macros – Examples
00:07:00
-
Section 3-04-02-Keyword positional and mixed params
00:06:00
-
Section 3-04-03-Conditional Logic in Macros
00:11:00
-
Section 3-05-Macro Functions
00:12:00
-
Section 3-05-Options Statement- mprint-mlogic-symbolgen
00:13:00
-
Section 3-07-Connecting the two worlds – Call Symput – Symget
00:14:00
-
Section 3-09-01-02- Bringing data into SAS using Import Wizard
00:04:00
-
Section 3-09-02- Bringing data into SAS using LIBNAME statement
00:05:00
-
Section 3-09-03- Bringing data into SAS using FILENAME
00:05:00
-
Section 4-00- Section Overview – Proc SQL
00:01:00
-
Section 4-01-01-Proc SQL – copying data
00:13:00
-
Section 4-01-02-Proc SQL – filtering data
00:07:00
-
Section 4-01-03-Proc SQL – sorting data
00:08:00
-
Section 4-01-04-Proc SQL – removing duplicates
00:05:00
-
Section 4-02-01-Proc SQL – Union
00:09:00
-
Section 4-02-02-Proc SQL – Except
00:04:00
-
Section 4-02-03-Proc SQL – Intersect
00:02:00
-
Section 4-03-00-Merging data using Joins-Introduction
00:08:00
-
Section 4-03-01-Proc SQL – inner join
00:14:00
-
Section 4-03-02-Proc SQL – full join
00:08:00
-
Section 4-03-03-Proc SQL – left and right joins
00:07:00
-
Section 4-04-01-Proc SQL – creating macro vars
00:07:00
-
Section 5-00- Bonus lecture
00:02:00
-
Resources – Advanced SAS Programming Using MacrosSQL
-
Assignment – Advanced SAS Programming Using MacrosSQL
-
Duration:4 hours, 2 minutes
-
Access:1 Year
-
Units:35
Want to get everything for £149
Take Lifetime Pack
