Contact No  : +91 8050922145
Skype ID      :  sas.training25
Email ID       :  neha.eduvercity@gmail.com,
                       neha.j@eduvercity.com

Base and Advance SAS

Base & Advance SAS course is entry level program for candidates those looking career in analytics. In this course you can learn how to write SAS programs and build logics using SQL and macro to develop the solution for handling different type of client requirement. This course enhance knowledge and programming skills as a professional SAS programmer. During the training, provided daily practice assignments help candidate to get fare idea about how to write the code to develop high quality reports.

Training Duration:

45 Days

Mode of Training:

Option 1: Instructor Led online training.
Option 2: Instructor led classroom training.

Take Away:

Soft Copy of Books
Class notes,
Coding for reference,
Assignments for practice
Dump questions for certification exam preparation
Interview questions,
Resume preparation.

Course Content / Topics:

Introduction

Introduction of SAS software.
Industries using SAS
Components of SAS System.
Architecture of SAS system.
Functionality of SAS System.
Introduction of SAS windows.

Working in the SAS Environment

Functionality of SAS Windows.
Creating and managing SAS Libraries.
Overview of SAS Data states.
Types of Libraries.
Storing files temporarily and permanently.
Referencing SAS files.

Creating database from raw data

Steps to create a SAS dataset.
Creating SAS dataset using text file.
Creating SAS dataset using text file with delimiters.
Creating SAS dataset using structured text file.
Creating SAS dataset using unstructured text file.
Creating SAS dataset using Excel file.
Creating SAS dataset using Access file.
Creating SAS dataset using values inside the code.

Creating AND Redefining variable

Use with different conditional statements.

Debugging Error Message

DEBUGGING syntax ERROR MESSAGES

Automatic Variables

Use of automatic variables.
Types of automatics variables.
Use of _N_, _ERROR_, _NULL_.
Testing your programs.
Using put statement.
Automatic Variable.

Output delivery system

Concepts of output delivery system. How ODS works and viewing output of ODS in different format. HTML, RTF, PDF etc..

Combination the dataset

One-o-one reading
One to many
Many to many
Concatenation
Interleaving,
Match merge

Functions

Character function
Numerical function
Arithmetical function
Mathematical function
Date Function

Sampling method

Random sampling

Loops in SAS: Do Loops

Loops are used to iterate through every observation for specified number of times to obtain a desired result

Types of Loops:
        Do Loop
        Do While
        Do Until

Array

Definition of array
Example of array

Procedure in SAS

Procedure Format.
Procedure Contents.
Procedure Options.
Procedure Append.
Procedure Compare.
Procedure Transpose.
Procedure Print.
Procedure Import.
Procedure Export.
Procedure Datasets.
Procedure Rank
Procedure Tabulate.
Procedure Chart, Gchart, Gplot.
Procedure Report.

Advance SAS Topics

Advance programming - Proc SQL

Performing Queries Using PROC SQL
Performing Advanced Queries Using PROC SQL
Combining Tables Horizontally Using PROC SQL
Combining Tables Vertically Using PROC SQL
Creating and Managing Tables Using PROC SQL
Creating and Managing Indexes Using PROC SQL

Advance programming - Macro

Introduction to Macros.
Defining Macro facility.
Generating SAS code using Macros.
Placing text using Macro variable.
Passing Macro Elements.
Macro Execution Process.
Macro Statements.

GRAPHS

Introduction to graphics.
Introduction to graphics.
Types of Graphics (with latest models)
Defining procedure Graphics.