SAS Certification Training

Data Analysis with SPSS: General Aspects, Workflow, Critical Issues

SPSS: General Description, Functions, Menus, Commands

SPSS File Management

Defining Variables

Manual Input of Data

Automated Input of Data and File Import

Excel Data : Initial Preparation

Check Cell Range of Data

Give Variable Names

Store basic Checks Max Min Mean

Import into SPSS

In Notepad or Text Pad

Check Total No of Rows

How many Rows Per Case

How Many Variables

Import Text File

The SAS programming process.

Submitting a SAS program

Using SAS programming tools.

Understanding SAS syntax.

Diagnosing and correcting syntax errors

Mastering fundamental concepts

Understanding SAS data.

Accessing data through libraries.

Importing data into SAS.

Exploring data.

Filtering rows.

Formatting columns.

Sorting data and removing duplicates.

Reading and filtering data.

Computing new columns.

Conditional processing.

Enhancing reports with titles, footnotes, and labels.

Creating frequency reports.

Creating summary statistics reports.

Exporting data.

Exporting reports.

Using Structured Query Language in SAS.

Joining tables using SQL in SAS.

setting up for this course

understanding DATA step processing

directing DATA step output

creating an accumulating column

processing data in groups

understanding SAS functions and CALL routines

using numeric and date functions

using character functions

using special functions to convert column type

creating and using custom formats

creating custom formats from tables

concatenating tables

merging tables

identifying matching and nonmatching rows

using iterative DO loops

using conditional DO loops

restructuring data with the DATA step

restructuring data with the TRANSPOSE procedure

What is an Interview

Tips to clear an Interview

Common Interview questions and answers

SAS Interview Questions and Answers

Resume Building Guide

Career roadmap and certifications

Attempt for related Global Certification Exam

Start applying for Jobs

Setting up for this course.

DATA step review.

Using a variety of advanced functions.

Performing pattern matching with Perl regular expressions.

Defining and referencing one-dimensional arrays.

Doing more with one-dimensional arrays.

Defining and referencing two-dimensional arrays.

Declaring hash objects.

Defining hash objects.

Finding key values in a hash object.

Writing a hash object to a table.

Using hash iterator objects.

Creating picture formats with the FORMAT procedure.

Creating functions with the FCMP procedure.

Why SAS macro

Setting up for this course.

Program flow.

Creating and using macro variables.

Macro functions.

Using SQL to create macro variables.

Using the DATA step to create macro variables.

Indirect references to macro variables.

Defining and calling a macro.

Macro variable scope.

Conditional processing.

Iterative processing.

Storing macros.

Generating data-dependent code.

Validating parameters and documenting macros.

Setting up for this course.

Overview of SAS Foundation.

Course logistics.

Course data files.

Introducing the Structured Query Language.

Overview of the SQL procedure.

Exploring tables.

Specifying columns.

Sub-setting data.

Presenting data.

Summarizing data.

Creating and managing tables.

Using DICTIONARY tables.

Introduction to SQL joins.

Inner joins.

Outer joins.

Complex SQL joins.

Noncorrelated subqueries.

Correlated subqueries.

In-line views.

Creating views with the SQL procedure.

Subqueries in the SELECT clause.

Remerging summary statistics.

Introduction to set operators.

The INTERSECT operator.

The EXCEPT operator.

The UNION operator.

The OUTER UNION operator.

Interfacing PROC SQL with the macro language.

Creating data-driven macro variables with a query.

Using macro variables in SQL.

Overview of SAS/ACCESS technology.

SQL pass-through facility.

SAS/ACCESS LIBNAME statement.

PROC Fed SQL.

What is an Interview

Tips to clear an Interview

Common Interview questions and answers

SAS Advanced Interview Questions and Answers

Resume Building Guide

Career roadmap and certifications

Attempt for related Global Certification Exam

Start applying for Jobs

Overview of BI concepts

Why we need BI

Introduction to SSBI

SSBI Tools

Why Power BI

What is Power BI

Building Blocks of Power BI

Getting started with Power BI Desktop

Get Power BI Tools

Introduction to Tools and Terminology

Dashboard in Minutes

Refreshing Power BI Service Data

Interacting with your Dashboards

Sharing Dashboards and Reports

Power BI Desktop

Extracting data from various sources

Workspaces in Power BI

Data Transformation

Measures and Calculated Columns

Query Editor

Introduction to Modelling

Modelling Data

Manage Data Relationship

Optimize Data Models

Cardinality and Cross Filtering

Default Summarization & Sort by

Creating Calculated Columns

Creating Measures & Quick Measures

What is DAX

Data Types in DAX

Calculation Types

Syntax, Functions, Context Options

DAX Functions

Date and Time

Time Intelligence

Information

Logical

Mathematical

Statistical

Text and Aggregate

• Measures in DAX

• ROW Context and Filter Context in DAX

• Operators in DAX -Real-time Usage

• Quick Measures in DAX -Auto validations

• PowerPivot xVelocity & Vertipaq Store

• In-Memory Processing: DAX Performance

History of R

Advantages and disadvantages

Downloading and installing

How to find documentation

Using the R console and R Studio

Getting help

Learning about the environment

Writing and executing scripts

Object oriented programming

Introduction to vectorised calculations

Introduction to data frames

Installing and loading packages

Working directory

Saving your work

Variables and assignment

Data types

Numeric, character, Boolean, and factors

Data structures

Vectors, matrices, arrays, data frames, lists

Indexing, sub-setting

Assigning new values

Viewing data and summaries

Naming conventions

Objects

Built-in data

Reading data from structured text files

Reading data using ODBC

Save a workbook as a template,

copy macros between workbooks,

reference data in another workbook,

reference data by using structured references,

enable macros in a workbook,

display hidden ribbon tabs

Restrict editing,

protect a worksheet

configure formula calculation options

protect workbook structure

manage workbook versions

encrypt a workbook with a password

Create custom number formats

populate cells by using advanced Fill Series options

configure data validation

Create custom conditional formatting rules

create conditional formatting rules that use formulas

manage conditional formatting rules

Create custom color formats,

create and modify cell styles,

create and modify custom themes,

create and modify simple macros

insert and configure form controls

Display data in multiple international formats

apply international currency formats,

manage multiple options for Body and Heading fonts

Perform logical operations by using AND, OR, and NOT functions;

perform logical operations by using nested functions

perform statistical operations by using SUMIFS, AVERAGEIFS, COUNTIFS

functions

Look up data by using the VLOOKUP function,

look up data by using the HLOOKUP function,

look up data by using the MATCH function,

look up data by using the INDEX function

Reference the date and time by using the NOW and TODAY functions,

serialize numbers by using date and time functions

Reference the date and time by using the NOW and TODAY functions

import, transform, combine, display, and connect to data

consolidate data

perform what-if analysis by using Goal Seek and Scenario Manager

use cube functions to get data out of the Excel data model

calculate data by using financial functions

Trace precedence and dependence

monitor cells and formulas by using the Watch Window

validate formulas by using error checking rules,

Evaluate formulas

Name cells,

name data ranges,

name tables,

manage named ranges and objects

Add trendlines to charts,

create dual-axis charts,

save a chart as a template

Create PivotTables,

modify field selections and options,

create slicers,

group PivotTable data,

reference data in a PivotTable by using the GETPIVOTDATA function,

add calculated fields,

format data

Create PivotCharts,

manipulate options in existing PivotCharts,

apply styles to PivotCharts,

drill down into PivotChart details

Overview

The History of VBA

Why VBA

VBA Summary

Active sheet, Active cell, offset, sheet add, rename, etc.

Static & Dynamic

Array functions

Filter, cut, copy, paste, remove duplication, etc.

File system basics

Understanding file permissions

Setting file permissions

Accessing files

Writing to files

Deleting files

Reading files

Examining file details

Working with directories

Viewing directory content

If statements

Else and elseif statements

Logical operators

And. OR, Not. Go to Statements

Switch statements

While loops

For loops

For each loops

do while

do until

Continue

Break

Understanding array pointers

Subroutine

Passing value to sub- procedure

Message box

VBA Inbuilt functions

Passing values in functions

Workbook and worksheet functions

Keywords

Difference between sub-routines and functions

Creating own functions in VBA for Excel