About SAS

SAS can be described as the software around which the whole analytics industry was built……well that may be an exaggeration, but SAS commands on overwhelming market share in the advanced analytics tools. As per an IDC report SAS has a 35% market share, more than double its nearest competitor. It has been around for more than 45 years and is now synonymous with Analytics.

Who should take this Training?

Business Intelligence professionals
Software developers and architects
Project managers
ETL, SQL, data warehouse and analytics professionals
Mainframe and testing professionals
Graduates wanting to enter Big Data analytics

Prerequisites

Basic knowledge of SQL can help.

Course Content

Day 1 :
 Introduction To SAS System & Architecture
 Brief discussion on SAS Product Suites.
 Introduction to ETL and Reporting Concepts.
 Introduction to SAS interface.
 The Microsoft Windows User Interface
 The Editor Window
 The Log window
 Output Window
 Explorer Window
 Results Window
 SAS Variables & Datasets.
 Dataset Options with examples.
 Operators in sas.
 Introduction to SAS Libraries and options.
 Reading Raw data
 Infile Statement With Options
 Working With External Files & Options
 Handling multiple observations.

Day 2:
 Input

 Date Functions
 Mathematical & Numerical Functions
 SAS ODS :
· Creating RTF File
· Creating Html File
· Creating Pdf File

Day 3:
 Conditional Execution on SAS.
 Where
 If/Else
 Case statement
 Do loops
 Merging in SAS
 First. And last.
 Overview Of Methods For Combining Sas Data Sets.
 Creating and drooping variables in a dataset.
 Arrays and Array Processing.

BASE SAS PROCEDURES
 Proc sort
 Proc Print
 Proc Means
 Proc Freq
 Proc Copy
 Proc Summar
 Proc Append
 Proc Dataset
 ProcContents
 Proc Delete
 Proc Format
 Proc Import
 Proc Export
 · Frequency Report
 · One-Way Frequency Report
 · Cross Tabular Frequency Report
 · Summary Statistics

Day 4:
 Creating A List Report
 · Define Statement
 · Order Usage and Group
 · Tabulate Procedure
 · One-Dimensional Tables
 · Two-Dimensional Tables
 · Obtaining A Total
 · Analysis Variables with options
 · Summary Statistics

Introduction to SAS Sql:
 · Introduction To SAS/ SQL
 Features
 ·Uses
 Terminology

Data Types, Key Words, & Operators
 · Formatting Output
 · Group By Clause
 · Order By Clause
 · Having Clause
 · Case Expression and Conditional Logic.
 · Creating ,Populating & Deleting Tables
 · Alter Table Statement
 · Changing Column’s Length
 · Joins
 · Renaming A Table & Columns
 · Views

Day 5 :
 Introduction to SAS Macros :
· Macro Concepts
· Macros And Macro Variables
· Creating Macro Variables
· Using Macro Variables
· Creating Modular Code With Macros
· Invoking A Macro
· Adding Parameters To Macros
· Macros With Conditional Logic
· Using Various Procedures In Macros
· Automatic Variables
· Macro Functions
· Including External Macros

Call Now- +91-921-276-0556

Send a Query









Tai Infotech Pvt Ltd, 2017 All Rights Reserved