SAS Course Content

SAS usage:


This course is highly useful to people who are looking for the jobs at different industries like Clinical,Banking,Finance, Retail, Pharma, Insurance, Market Research. Also this course helps for already employed to their next step in career, especially on BPO & KPO industries.


There is high scope of getting SAS & Excel jobs for the people with below qualifications like

  • B.Sc & M.Sc (Statistics)
  • B.A & M.A (Economics)
  • B.Sc & M.Sc (Maths)
  • B.tech & M.tech
  • B.com & M.Com
  • M.B.A & M.C.A- Any specialization
  • Graduate in Microbiology
  • Graduate in Biotech
  • B.Pharmacy & M.Pharmacy
  • B.Sc & M.Sc (Chemistry)


SAS 9.2 & 9.3 COURSE CONTENT DETAILS:


SAS/BASE


BASIC THEORY OF SAS AND IT’S RULES ETC..

  • 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 IT’S 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 VARIABLE

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