Embark on a transformative journey into the realm of data mastery with our comprehensive course, “Advanced SAS Programming Using MacrosSQL.” From demystifying the intricacies of SAS Studio to unlocking the potential of Proc SQL, this course is a gateway to proficiency in SAS programming and macro scripting. The curriculum, thoughtfully designed to accommodate learners of all levels, takes you through the essential foundations of SAS, the nuances of macro variables, and the power-packed functionalities of Proc SQL. Dive into the world of nested macro variables, conditional logic, and data manipulation, all while honing your skills through practical examples. This course isn’t just about learning syntax; it’s a hands-on exploration that empowers you to seamlessly connect the dots between SAS Studio and Proc SQL, bringing your data analytics capabilities to new heights.
Learning Outcomes
This Advanced SAS Programming Using MacrosSQL does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced SAS Programming Using MacrosSQL was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.
Advanced SAS Programming Using MacrosSQL | |||
Unit - 1 | |||
Section 0-00- Why SAS | 00:01:00 | ||
Unit - 2 | |||
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 | ||
Unit - 3 | |||
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 | ||
Unit - 4 | |||
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 | ||
Unit - 5 | |||
Section 5-00- Bonus lecture | 00:02:00 |
Have you ever scrolled through social media and been blown away by captivating edits? Maybe it was a seamless transition, …
0
Imagine diving into your photos, not just looking at them. Imagine transporting viewers to the heart of your scene, letting …
0
Imagine transforming your stunning photographs into captivating moving narratives. Learn After Effects for Photography unlocks a world of creative possibilities, …
0