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
Promo Code SAVE25
Use promocode SAVE25 to get upto 25% discount on offer price Minimum Order value - Rs 50/-. Offer is valid for all Jagran Josh products.
Section 1: Introduction
1 Introduction to Advanced SAS04:39
Section 2: Macro Applications
2 Why MACRO? 06:45
In this tutorial we ar
Promo Code SAVE25
Use promocode SAVE25 to get upto 25% discount on offer price Minimum Order value - Rs 50/-. Offer is valid for all Jagran Josh products.
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 ... Read More
© 2023 Josh Shop. All Rights Reserved.