Advance SAS tutorial (9.5 hour long PROC SQL and SAS Macro video)

This advance tutorial consists of 3.5 hour PROC SQL and 6 hours of SAS Macro. This video is created from complete tutorials of PROC SQL and SAS Macro uploaded earlier.
SAS Macro quoting function papers.
Link to Art Carpenter paper regarding SAS Macro libraries

Chapters
0:00 Topic Introduction for PROC SQL
1:03 Proc SQL tutorial introduction
2:10 Basic syntax, select and others
23:16 Where Clause
54:09 Aggregate functions and Group by
01:25:27 Set Operators
01:52:14 Joins
02:41:48 Subquery
03:04:05 Create and Alter Statements
03:16:39 Insert, Update, Delete and Drop statements
03:34:11 Conclusion of SQL tutorial
03:34:44 Topic Introduction for SAS Macro Topic
03:35:58 Part 1 SAS Macro Introduction.
04:02:43 Part 2 Macro variables and %let statements.
04:30:33 Part 3: Macro and Macro parameters.
05:00:03 Part 4: ​ Conditional and iterative macro statement
05:36:56 Part 5: Creating macro variables with Proc SQL and three ways to use them
06:19:03 Part 6: CALL SYMPUT/CALL SYMPUTX and comparison with PROC SQL into
06:47:55 Part 7a (Macro functions): Macro Quoting functions
07:32:53 Part 7b :Evaluation, %sysfunc and character based Macro functions.
08:06:45 Part 8: Macro Libraries.
08:32:46 Part 9: Macro facility interaction with Call execute
09:02:22 Part 10: Scope of Macro Variables
09:26:44 SAS Macro and final conclusion.

[raselahmed-yttl]

I am certified SAS programmer in England.It's a very good video to learn macro and sql

[rogerward]

This is really nice of you to go to all this work! Thank you.

[kaivalyagala]

Please keep real time work on SAS it going useful

[reeteshsingh]

If you could make video on TABLES, LISTINGS, GRAPHS and FIGURES in descriptive manner like this video, it would be very helpful for aspirants. Thank you in advance.

[roverstravel]

If u could make video on interview questions with solution..😊