sas online training

                          sas online training 

We provide best Sas online training in Hyderabad by experienced and real time expert faculty in Sas.  

Course fee :- Please contact  admin@saptrainings.com for pay details of this SAS ONLINE TRAINING classes.

TECHNICAL AREAS

I   Getting started using SAS Software

•  History of SAS

•  Introduction to SAS

• Execution of SAS Programs (Compile & Execution)sas1

•  Overview of SAS Software

•  Rules for SAS Statements

•  SAS Comments

•  SAS Data set definition

•  SAS Data Types

•    Two Parts of SAS Program

•   Difference between DATA and PROC Steps

•   SAS Windowing Environment (Editor, Log, Output, Explorer, Results windows)

•    Submitting a SAS Program

•   Reading SAS log and Output window

•   Referencing files/folders into SAS

•   SAS Libraries (Permanent & Temporary)sas2

•  SAS Data sets with SAS Explorer

•  SAS Products/Modules

•  SAS in different Sectors

•  SAS System Options

•  SAS Global Statements

 Base SAS

II.Data Access

• SAS Programs (Saving, Editing, Opening a stored program)

• Steps to create a SAS Dataset from raw data

• Referencing a SAS Library

• Storage of Dataset (Temporarly & Permanentely)sas4

• Informats & Formats

• Processing of data through EBCDIC and ASCII

• Methods for getting data into SAS

o  Entering data in a viewtable

o Reading internal raw data (List, Column, Formated & Mixed Inputs)

o Reading external raw data (Infile Statement)

o Import Wizard method

o Proc Import

• Testing your Program

III. Data Management

• Reading data from one dataset to another dataset

• Subsetting Data

• Creating and Modifing Variablessas3

• SAS Dataset Statements

• SAS Dataset Options

• SAS Functions (Numeric, Character, Date & Time)

• Merge Concept

• Index Concept

• Creating & Applying user defined formats

• Changing variable typessas5

• Conditional Statements

o If statement

o Nested if statement

o  Do loop

o Do While & Do Until

o Arrays  

Basic SAS Procedures

sas6

• Proc Contents

• Proc Print

• Proc Append

• Proc Sort

• Proc Format

• Proc Compare

• Proc Copy

• Proc Datasets

IV. Data Analysis

Proc Freq

Proc Transpose

Proc Standard

Proc Univariate

Proc Means/Summary

Proc Corr

Proc Reg

V. Data Presentation

ODS Concept

SAS output in different panels

RTF

HTML

PDF

XML

MS-Office

Reporting Procedures

Proc Print

Proc Tabulate

Proc Report

Proc Export

                                   Advanced SAS

VI. SAS SQL

Introduction to SQL

SQL Terminology

SQL Statements

Introduction to SAS SQL (Proc SQL)

Importance of PROC SQL

Creating & Deleting Tables

Overview of SELECT Statement

FROM Clause

ORDER BY Clause

GROUP BY Clause

WHERE Clause

HAVING Clause

SQL Joins & Views

Case Operator

Working on Indexes

Connecting to various Databases

Connect to & Disconnect from Statements

VII. SAS MACROS

Introduction to Macros

Uses of Macros

Macro Concepts (Macros Processor, Components)

Types of Macros (Automatic & User defined)

Macro Variables (Local & Global)

Creating Macro Variables

%Let Statement

%Do Statement

%Local

%Global

%Macro (with or without parameters)

Call Symput in Data Step

Into clause in Proc SQL

Macro Parameters (Key word and Positional)

Macro Functions

Macro Conditions (%If, %If %then….)

Invoking Macros

Debugging Macro Errors (Mprint, Mlogic, Symbolgen)

VIII. Additional SAS

SAS Coding Standards

Efficiency of SAS Programming

Error Handling Concepts

SAS in other Operating Systems (UNIX & Mainframes)

 SAS BI Suite

Overview on SAS BI Suite

SAS Enterprise Guide

SAS DI (Data Integration) Studio

SAS Management Console

SAS OLAP Cube Studio

SAS Web Report Studio

SAS Info Map Studio

SAS Info Delivery Portal

SAS Enterprise Miner

FUNCTIONAL AREAS

IX.Levels of Data

What is Data or Raw Data

What is Structured & Unstructured data

Levels of Data (Primary & Secondary Data)

Types of Data (Qualitative & Quantitative Data)

X.Introduction to Statistics

Basic Statistics

Measures of Dispersion

Measures of Central Tendency

Univariate Techniques

Bivariate Techniques

Multivariate techniques

Regression Analysis

Cluster Analysis

Factor Analysis

Discriminant Analysis

Data Mining

Data Modelling

Predective Analysis

XI.Data Warehousing Concepts

Dimensional Data

Transactional Data

Fact/Basket level Data

3rd Party Data

ETL

OLAP

OLTP

•Data Mart

XII.Domain or Industry Knowledge

Retail (FMCG/CPG)

Finance (BFSI)

Clinical Trails

Telecommunications

Market Research

TECHNO-FUNCTIONAL AREAS

XIII.Project on any one of the domain

Case Studies on each domain

Retail (FMCG/CPG)

Finance (BFSI)

Clinical Trails

• Telecommunications

•  Market Research

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *