Home
Course
IT & Software
Advanced SAS Programming Using MacrosSQL

See the Curriculum Section for materials and enjoy learning with Imperial Academy.

Course Curriculum

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
Resources
	Resources – Advanced SAS Programming Using MacrosSQL	00:00:00