Advance SAS tutorial (9.5 hour long PROC SQL and SAS Macro video) скачать в хорошем качестве

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. https://www.lexjansen.com/nesug/nesug... https://support.sas.com/resources/pap... Link to Art Carpenter paper regarding SAS Macro libraries https://support.sas.com/resources/pap... 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. For any queries please contact us at [email protected].