Advanced SAS

4 out of 5
4
6 reviews

What advanced SAS?

Write and execute SAS code during your exam. During this performance-based exam, candidates will access a SAS environment. Building on your skills earned with a Base Programming Credential, you will now work with SQL, the SAS Macro facility, and advanced coding techniques such as arrays, hash objects.

Software Installation : Currently software installation is a paid one. You need to do it from system administrator. The total software which consists of around 17 Gb. It will take 2 Hours to do the installation.

System requirements :

Processor : i3 and above

RAM : 4GB and above [preferable 8 GB Best ]

Harddisk : SSD Harddisk with 250 GB OR Above  / other harddisk also its ok

Target Audience :

To do this course the Base SAS course completion is primary .once you have the knowledge on the Base SAS then you can step into the advanced SAS.

Materials :

Books and Daily notes will be provided by us along with that recording also will be provided for reference . Step by step notes will be provided and excersises also.

Sample Videos : We request you that first don’t join the course directly as we provide the sample videos in the cirriculam first watch that try to understand. If you understand and feel comfortable with trainer explanation then gohead for classes. Join the course.

Working hours  : 9:00 am ist  to 8 pm ist .

SAS SQL Course Contents

Chapter 1 : Introduction

1
Structured Query Language
2
SAS Functions
3
Case Study

Chapter 2 : Basic Queries

1
Overview of sql procedure
2
Specifying Columns
3
Specifying Rows
4
Presenting data
5
Summarizing data
6
Exercises

Chapter 3 : Combining Tables

1
Overview
2
Joins
3
Complex Joins
4
Set operators
5
Exercises

Chapter 4: Creating and modifying tables and views

1
Creating tables
2
Creating views
3
Creating Indexes
4
Maintaining Tables
5
Exercises

Chapter 5 : Additional SQL features

1
Setting PROC SQL Options
2
Dictionary Tables and Views
3
Interfacing PROC SQL with macro language
4
Program testing and performance

Chapter 6: Overview of table and column name

1
Table and Column names Sorted by Column names
2
Table and column names Sorted by table names
3
Partial table listings

Chapter 7: Dictonary Tables

Chapter 8: Highly Advanced Concepts

Chapter 9: Top 30 professional Programming techniques

SAS MACROS

Chapter 1: Introduction

1
Purpose of the macro facility
2
Program flow
3
Course data

Chapter 2 : Macro Variables

1
Introduction to Macro variables
2
Automatic Variables
3
Macro Variable References
4
User defined macro variables
5
Delimiting macro variables names
6
Macro Functions

Chapter 3: Macro definitions

1
Defining and calling a Macro
2
Macro Parameters

Chapter 4: DATA step and SQL Interfaces

1
Creating Macro variables in the data step
2
Indirect reference to macro variables
3
Retrieving macro variables in the data step
4
Creating macro variables in SQL

Chapter 5 : Macro Programs

1
Conditionally Processing
2
Iterative processing
3
Global and Local Symbol tables

Chapter 6 : Macro Execution Process

Chapter 7: Advanced Concepts

Chapter 8: Top 30 professional Programming techniques

Faq Content 1
Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Add to Wishlist
Get course
Enrolled: 76 students
Duration: 30 Days
Lectures: 41
Video: Available
Level: Advanced

Archive

Working hours

Monday 9:00 am to 8 pm ist
Tuesday 9:00 am to 8 pm ist
Wednesday 9:00 am to 8 pm ist
Thursday 9:00 am to 8 pm ist
Friday 9:00 am to 8 pm ist
Saturday 9:00 am to 8 pm ist
Sunday Closed