SAS Training in Gurgaon

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

Define and use macro variables.

Use macro variable name delimiter. (.)

Use INTO clause of the SELECT statement in SQL.

Use the SYMPUTX routine in a DATA Step.

Control variable scope with:

• %GLOBAL statement

• %LOCAL statement

• SYMPUTX scope parameter

Define and use character arrays.

Define and use numeric arrays.

Create variables with arrays.

Reference arrays within a DO loop.

Specify the array dimension with the DIM function.

Define arrays as temporary arrays.

Load initial values for an array from a SAS data set.

Declare hash and hash iterator objects

• Dataset argument

• Ordered argument

• Multidata argument

Date and Time

Time Intelligence

Information

Logical

Mathematical

Statistical

Text and Aggregate

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