Course Description :-

This training program is completely hands-on and it is taught the way it is being used in the Industry. The program covers most widely used advanced SAS features such as SAS MACRO and SAS SQL in the Industry. One must take training in Base SAS in order to take the training in advanced SAS. We have included good number of practical examples and programming using SAS for a better understanding. This course is ideal for students, professionals and anyone interested in a career in SAS. We will be covering the following modules in this course:

Overview of SAS MACRO

Macro Statements, Macro Variables, Macro Variable References
Defining a Macro. Calling a Macro
Global Symbol Table, Local Symbol table
Macro Programming
Overview of SAS Structured Query Language
PROC SQL
Select Clause, Where Clause, Group by Clause, Having Clause, Order by Clause
SQL functions
Sub Queries
SQL Joins
SQL Tables
SQL Views

Curriculum

Section 1: Introduction

Lecture 1 - Introduction to SAS

Section 2

Lecture 2: Macro Applications

Lecture 3- Developing Macro applications

Lecture 4: Token

Section 3: Macro Variables
 

Lecture 5- Macro variables

Lecture 6- Macro variables Examples

Lecture 7- Macro variables Demo

Lecture 8- Defining and Calling Macro

Lecture 9- Demo 

Section 4: Macro - Putting Code

Lecture 10- Macro - Putting Code 

Lecture 11- Macro Programming

Lecture12 - Example for Macro Programming


Section 5: SAS Macro

Lecture 13- Positional Parameters

Lecture 14 - Positional Parameters Example

Lecture 15 - Where are Macro Variables Stored?  

Lecture 16 - Creating & Updating Variables

Section 6: SQL

Lecture 17- SAS with SQL

Lecture 18 - Understanding SQL Procedure

Lecture 19 - How to use SQL in SAS?  

Lecture 20 - NOEXEC Keyword

Lecture 21- Practical Examples- NOEXEC  
?
Lecture 22- Average Function

Lecture 23- Minimum Function

Lecture 24- Count Function
 
Lecture 25- Executing Count Function 

Lecture 26 - Group by Clause

Lecture 27 - Executing Group by and Having Clause 

Lecture 28 - Order By Clause

Lecture 29 - Executing Order By Clause

Lecture 30 - Sub Query

Lecture 31 - Executing Sub Query

Lecture 32 - What are SQL Joins?

Lecture 33- Syntax for the Outer Join

Lecture 34 - Practical example for Joins

Lecture 35- Creating a Table in SQL

Lecture 36 -  Understanding SQL View

Lecture 37 - Inserting Data into Table

Lecture 38 - Techniques for Programming Efficiency

Lecture 39 - Practical Example for Creating Table

Lecture 40 - Practical Example for Inserting Data into Table

Lecture 41- Practical Example for Deleting Record from Table

 Lecture 42 - Practical Example for View

How to access :-

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

Benefits of online course:

1. Lifetime access

2. High Quality Content.

3. Learn Anywhere Anytime & at Your Pace

4.24X7 Customer Support

5. Complete Student Support throughout the Program

6. Online Video Training Material

7. Course completion certificate

*offer valid for a limited time period

For any query talk to our expert

Mob:- +918587999769