SAS WINDOWING ENVIRONMENT
ALL WINDOWS (WINDOW, OUTPUT WINDOW, EDITOR WINDOW, RESULTS WINDOW & EXPLORE WINDOW Etc.) WILL BE EXPLAINED
CREATION OF LIBRARIES (Temporary &Permanent)
SAS PROGRAMMING (BRIEFLY)
DATA STEP
PROC STEP
WAYS TO ACCESS THE DATA INTO SAS ENVIRONMENT
BACK END PROCESS OF DATASTEP
INSTALLATION PROCESS EXPLANATION.

DATA STEP

DATA STATEMENT & DATASET OPTIONS

INFILE STATEMENT & OPTIONS

INPUT STATEMENT &STYLES & OPTIONS

DATALINES STATEMENT

ATTRIBUTES OF THE VARIABLES

LENGTH, LABEL STATEMENTS

INFORMATS & FORMATS

HOW DATES WORKS IN SAS

OTHER STATEMENTS

SUM STATEMENT

RETAIN STATEMENTS

GOTO STATEMENT
LINK STATEMENT
RETURN STATEMENT
KEEP STATEMENT
DROP STATEMENT
RENAME STATEMENT

FOLLOWING CONDITIONAL STATEMENTS FOR DATA FILTRATION & LOOPS

IF STATEMENT, IF/THEN STATEMENT, IF/THEN/ELSE, IF/THEN OUTPUT, IF/THEN DELETE STATEMENTS
WHERE STATEMENT& IT’S OPERATORS
DO, DO ITERATIVE, DO UNTIL & DO WHILE STATEMENTS

COMBINING DATASETS

CONCATENATION
INTEREAVING CONCEPT
MERGE CONCEPT with all Joins
UPDATE
MODIFY

FUNCTIONS

CHARACTER FUNCTIONS
NUMERIC FUNCTIONS
DATE FUNCTIONS
ARRAYS

Numeric
char

OTHERS MISSING CONCEPTS
REVIEW OF DATASTEP

PROC STEP

UTILITY PROCEDURES

PROC CONTENTS AND OPTIONS
PROC COPY AND Its OPTIONS
PROC SETINIT (TO KNOW THE LISCENCE INFORMATION OF SAS SOFTWARE)
PROC DELETE
PROC PWENCODE
PROC APPEND
PROC SORT
PROC DATASETS
PROC OPTIONS
PROC COMPARE
PROC TRANSPOSE
PROC TRANSPOSE WITH MULTIPLE SCENARIOS
PROC RANK
PROC FORMAT
PROC IMPORT
PROC EXPORT
PROC CATALOG
PROC CPORT
PROC CIMPORT
PROC TEMPLATE
PROC MIGRATE
REVIEW OF UTILITY PROCEDURES

SAS/ACCESS

BASIC THEORY OF SAS/ACCESS

WAYS TO ACCESS DATA FROM DIFFERENT SOURCES LIKE

NOTEPADS, EXCEL, CSV, FILES, MS ACCESS, ORACLE, DB, SYBASE AND TERRADATA etc.…

SQL PASS THRU QUERY
LIBNAME STATEMENT
PROC DBLOAD
PROC ACCESS
REVIEW OF ACCESS PROCEDURES

REPORTING PROCEDURES

PROC PRINT
PROC TABULATE
PROC REPORT
_NULL_ REPORT (Data step Reporting)
REVIEW OF REPORTING PROCEDURES

SAS/GRAPHS & ODS CONCEPTS

PROC GPLOT
PROC GCHART
PROC SGPLOT
PROC ANNOTATE
ODS
REVIEW OF GRAPHS PROCEDURES

SAS/STAT

STATISTICAL PROCEDURES

PROC MEANS
PROC SUMMARY
PROC UNIVARIATE
PROC FREQ
PROC CORR
PROC REG
REVIEW OF STATS PROCEDURES

SAS/ADVANCED

SAS/MACROS

INTRODUCTION TO THE MACRO FACILITY IN SAS

PURPOSE OF THE MACRO FACILITY

MACRO VARIABLES

INTRODUCTION TO MACRO VARIABLES

Types Of Macro variables

Global
Local
Automatic

MACRO VARIABLE REFERENCES
USER DEFINED MACRO VARIABLES
DELIMITING MACRO VARIABLE NAMES
DELETING MACRO VARIABLES

MACRO FUNCTIONS

without parameters
with parameters
positional parameters
keyword parameters

MACRO DEFINITIONS

DEFINING AND CALLING A MACRO
MACRO PARAMETERS
MACRO STORAGE

DATA STEP AND SQL INTERFACES

CREATING MACRO VARIABLES IN THE DATA STEP
INDIRECT REFERENCES TO MACRO VARIABLES
RETRIEVING MACRO VARIABLES IN THE DATA STEP
CREATING MACRO VARIABLES IN SQL

PROC SQL:

SQL PASS-THROUGH QUERY WITH ALL CONCEPTS

CERTIFICATION CLASSES

DOMAIN SPECIFIC PROJECT:

Driving Projects by students

project provided with live data
Hands on experience will be provided for the project
Real time project support & guidelines provided
Clinical/Banking/Retail/Finance projects with complete details
Scope & object of project
Data cleaning & handling missing values
Frequency distributions of demographical variables
Error values reporting to client
Data management (combining multiple datasets & preparing final meaningful datasets)
Report generations & presenting to client
Data analysis & conclusion driving

FAQs

Interview prospect questions
explanation logics in faqs
Domain specific faqs

INTERVIEW HANDLING

Guidelines to handle interview
suggestions & precautions for clearing interview
trail run on interview.

PROVIDING ORACLE CLASSES (BELOW CONCEPTS WILL BE COVERED)

SQL (STRUCTURED QUERY LANGUAGE)

DDL (DATA DEFINITIONLANGUAGE)

CREATE
ALTER
I.ADD
II. MODIFY
III. DROP
IV. RENAME
TRUNCATE
DROP
RENAME
CREATING EXACT COPY OF A TABLE
CREATE A COPY WITHOUT DATA

DML (DATA MANIPULATION LANGUAGE)

INSERT
UPDATE
DELETE

TCL (TRANSACTION CONTROL LANGUAGE)

COMMIT
ROLLBACK
SAVE POINT

DCL (DATA CONTROL LANGUAGE)

GRANT
REVOKE

DRL/DQL (DATA RETRIEVAL/DATA QUERY LANGUAGE):

RETRIEVING DATA BY USING
SELECT CLAUSE

HANDLING NULL VALUES

NVL FUNCTION
NVL2 FUNCTION
NULLIF FUNCTION
COALESCE FUNCTION

DEFINING ALIAS NAMES

COLUMN ALIAS
TABLE ALIAS

INTEGRITY CONSTRAINTS

VARIOUS TYPES OF CONSTRAINTS

NOT NULL
UNIQUE
PRIMARY KEY CONSTRAINTS
FOREIGN KEY CONSTRAINTS
CHECK
DEFAULT
DROPPING CONSTRAINTS
ENABLING, DISABLING CONSTRAINTS
HOWTOTO TO CONSTRAINTS TO EXISTING TABLE
EXTRACT DATA FROM MORE THAN ONE TABLE

JOINS:

TYPES OF JOINS:

SELF JOIN
EQUI JOIN
NON EQUI JOIN
INNER JOIN

OUTER JOIN

I.LEFT OUTER JOIN
II.RIGHT OUTER JOIN
III. FULL OUTER JOIN
NATURAL JOIN
CROSS JOIN

CONDITIONAL CLAUSE

WHERE CLAUSE
ORDER BY CLAUSE
HAVING CLAUSE
GROUP BY CLAUSE

OPERATORS:

THE FOLLOWING OPERATORS WE USE IN ORACLE(SQL)

CONCATENATION OPERATORS
RELATIONAL OR COMPARISON OPERATORS
LOGICAL OPERATORS
SET OPERATORS
MULTIPLE-ROW COMPARISON OPERATORS
SQL *PLUS OPERATORS

PRE-DEFINED FUNCTIONS

CHARACTER FUNCTIONS
NUMBER FUNCTIONS
DATE FUNCTIONS
CONVERSION FUNCTIONS
NUMBER CONVERSION
DATE CONVERSION

Register for a FREE DEMO class to attend IT Training courses with our experts online trainers. Register now by filling the below form. Take a DEMO and see how our online training courses work for you.

Which course is right for me?

Speak to an IT online learning consultant today

on 844-OPTGHAR for FREE Tailored Advice.