Development
QLS
Business
Healthcare
Health & Fitness
Technology
Teaching
Lifestyle
Design
About This Course
See the Curriculum Section for materials and enjoy learning with Imperial Academy.
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
Subscribe to this course and 2,000+ top‑rated Training Express courses for your organization.
Try imperial academy business
Add to Cart
