• Category: Big Data & Analytics
• Product Type: Online Course

Section 1: Introduction 1 Introduction to Advanced SAS04:39 Section 2: Macro Applications 2 Why MACRO? 06:45 In this tutorial we are going to learn how Macro as a text processing facility is used for automating and customizing SAS code. 3 Developing Macro applications 07:12 In this tutorial we are going to learn the steps that can be used for developing macro applications 4 Token 08:33 In this tutorial we are going to learn about the concept of Tokenization which is used in SAS. We are also going to see the examples of word Token. Section 3: Macro Variables 5 Macrovariables 11:47 In this tutorial we are going to see what are Macrovariables. We are also going to see what is a Global Symbol table. 6 Macrovariables Examples 01:47 In this tutorial we are going to see some of the examples of Macrovariables. Thus we are going to see the User defined Macro variables. 7 Macrovariables Demo 07:31 In this tutorial we are going to see how to execute some of the commands. So lets try to do a demo session for executing the commands. 8 Defining and Calling Macro 07:57 In this tutorial we are going to learn how to define and create a Macro 9 Demo 03:46 Lets do one more demo and define and create another macro.   Section 4: Macro - Putting Code 10 Macro - Putting Code 09:10 In this tutorial we are going to learn how to put the code in Macro. 11 Macro Programming 04:41 In this tutorial we are going to learn about: Macro Programming 12 Example for Macro Programming 04:06 In this tutorial we are going to learn about: Example for Macro Programming Section 5: SAS Macro 13 Positional Parameters 07:20 In this tutorial we are going to learn about: Positional Parameters 14 Positional Parameters Example 04:24 In this tutorial we are going to learn about: Positional Parameters Example 15 Where are Macro Variables Stored? 06:50 In this tutorial we are going to learn about: Where are Macro Variables Stored? 16 Creating & Updating Variables 05:05 In this tutorial we are going to learn about: Creating & Updating Variables Section 6: SQL 17 SAS with SQL 04:58 In this tutorial we are going to learn about: SAS with SQL 18 Understanding SQL Procedure 07:55 In this tutorial we are going to learn about: Understanding SQL Procedure 19 How to use SQL in SAS? 05:41 In this tutorial we are going to learn about:   How to use SQL in SAS? 20 NOEXEC Keyword 02:40 In this tutorial we are going to learn about: NOEXEC Keyword 21 Practical Examples- NOEXEC 04:18 In this tutorial we are going to learn about: Practical Examples- NOEXEC 22 Average Function 03:43 In this tutorial we are going to learn about: Average Function 23 Minimum Function 03:33 In this tutorial we are going to learn about: Minimum Function 24 Count Function 05:20 In this tutorial we are going to learn about: Count Function 25  Executing Count Function 03:42 In this tutorial we are going to learn about: Executing Count Function 26 Group by Clause 07:07 In this tutorial we are going to learn about: Group by Clause 27 Executing Group by and Having Clause 04:50 In this tutorial we are going to learn about: Executing Group by and Having Clause 28 Order By Clause 07:12 In this tutorial we are going to learn about: Order By Clause 29  Executing Order By Clause 06:32 In this tutorial we are going to learn about: Executing Order By Clause 30 SubQuery 08:36 In this tutorial we are going to learn about: SubQuery 31 Executing SubQuery 07:21 In this tutorial we are going to learn about: Executing SubQuery 32 What are SQL Joins? 10:14 In this tutorial we are going to learn about: What are SQL Joins? 33 Syntax for the Outer Join 07:27 In this tutorial we are going to learn about: Syntax for the Outer Join 34 Practical example for Joins 04:58 In this tutorial we are going to learn about: Practical example for Joins 35 Creating a Table in SQL 07:11 In this tutorial we are going to learn about: Creating a Table in SQL 36 Understanding SQL View 09:57 In this tutorial we are going to learn about: Understanding SQL View 37 Inserting Data into Table 03:43 In this tutorial we are going to learn about: Inserting Data into Table 38 Techniques for Programming Efficiency 06:31 In this tutorial we are going to learn about: Techniques for Programming Efficiency 39 Practical Example for Creating Table 11:47 In this tutorial we are going to learn about: Practical Example for Creating Table 40 Practical Example for Inserting Data into Table 06:09 In this tutorial we are going to learn about: Practical Example for Inserting Data into Table 41 Practical Example for Deleting Record from Table 03:32 In this tutorial we are going to learn about: Practical Example for Deleting Record from Table 42 Practical Example for View 04:08 In this tutorial we are going to learn about: Practical Example for View   Type of Delivery - Self Paced Learning Course Duration - 5 Hours Course Duration - Lifetime Validity Certification - Yes   How to use? (Steps to use Study Material) Step 1 - eduCBA sends the redemption coupon along with the registration link. Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email id Step 4 - Login using your email id and password and start learning ... Read More