Business Analytics Using SAS by eduCBA - Online Course

by Jagranjosh

Business Analytics Using SAS by eduCBA - 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 ...View more

Specification

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

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

You May Also Be Interested In
Loading...
  • Rs. 999
  • Rs. 299
  • (70% Off)

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.

Best Sellers

Business Analytics Using SAS by eduCBA - Online Course
Business Analytics Using SAS by eduCBA - Online Course

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.

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

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

This website uses cookie or similar technologies, to enhance your browsing experience and provide personalised recommendations. By continuing to use our website, you agree to our Privacy Policy and Cookie Policy.OK