About This Course
Course Curriculum
-
Section 0-00- Why SAS00:01:00
-
Section 2-02- SAS Studio through SAS OnDemand- Registration00:04:00
-
Section 2-03- Logging-in to SAS after installation00:01:00
-
Section 2-04- SAS Interface and windows00:06:00
-
Section 3-00- Section Overview – Macros00:01:00
-
Section 3-01-Macro Variables – introduction00:14:00
-
Section 3-02-Application of macro variables00:13:00
-
Section 3-03-01-Nested macro vars00:11:00
-
Section 3-03-02-More on Ampersand resolutions using a cool example00:09:00
-
Section 3-04-00-SAS Macros – introduction00:10:00
-
Section 3-04-01-SAS Macros – Examples00:07:00
-
Section 3-04-02-Keyword positional and mixed params00:06:00
-
Section 3-04-03-Conditional Logic in Macros00:11:00
-
Section 3-05-Macro Functions00:12:00
-
Section 3-05-Options Statement- mprint-mlogic-symbolgen00:13:00
-
Section 3-07-Connecting the two worlds – Call Symput – Symget00:14:00
-
Section 3-09-01-02- Bringing data into SAS using Import Wizard00:04:00
-
Section 3-09-02- Bringing data into SAS using LIBNAME statement00:05:00
-
Section 3-09-03- Bringing data into SAS using FILENAME00:05:00
-
Section 4-00- Section Overview – Proc SQL00:01:00
-
Section 4-01-01-Proc SQL – copying data00:13:00
-
Section 4-01-02-Proc SQL – filtering data00:07:00
-
Section 4-01-03-Proc SQL – sorting data00:08:00
-
Section 4-01-04-Proc SQL – removing duplicates00:05:00
-
Section 4-02-01-Proc SQL – Union00:09:00
-
Section 4-02-02-Proc SQL – Except00:04:00
-
Section 4-02-03-Proc SQL – Intersect00:02:00
-
Section 4-03-00-Merging data using Joins-Introduction00:08:00
-
Section 4-03-01-Proc SQL – inner join00:14:00
-
Section 4-03-02-Proc SQL – full join00:08:00
-
Section 4-03-03-Proc SQL – left and right joins00:07:00
-
Section 4-04-01-Proc SQL – creating macro vars00:07:00
-
Section 5-00- Bonus lecture00:02:00
-
Resources – Advanced SAS Programming Using MacrosSQL