SAS 9.2 & 9.3 Online Training and Placement

  SAS 9.2 & 9.3 Training for OPT CPT Students

Online Training Courses
.Net Online Training Courses Java Online Training Courses SAP Online Training Courses Oracle Online Training Courses Software Testing Online Training Courses C Programming Online Training Courses C++ Programming Online Training Courses jQuery Online Training Courses UI Design Online Training Courses UNIX Online Training Courses Javascript Online Training Courses SQL & PLSQL Online Training Courses SAS Online Training Courses BI Reporter Tool Online Training Courses Microstrategy Online Training Courses Mainframes Online Training Courses Business Objects Online Training Courses Business Analysis Online Training Courses BPM Online Training Courses Hadoop Online Training Courses DataStage Online Training Courses Android Online Training Courses Linux Online Training Courses OBIEE Online Training Courses IBM Tools Online Training Courses PHP Online Training Courses AJAX Online Training Courses BizTalk Online Training Courses Data Warehousing Online Training Courses Embedded Systems Online Training Courses Google Technologies Online Training Courses Microsoft Technologies Online Training Courses Oracle DBA Online Training Courses Oracle Datawarehouse Online Training Oracle E-Business Suite Online Training PeopleSoft Online Training Courses Project Management Online Training Courses Autocad Online Training Courses Salesforce Online Training Courses Sharepoint Online Training Courses Softskills Online Training Courses System Networking Online Training Courses Web Design Online Training Courses BizTalk Server Online Training Courses Database Online Training Courses iPhone App Development Online Training Ruby On Rails Online Training Courses SEO Online Training Courses Shell Scripting Online Training Courses VMWare Online Training Courses Webmethods Online Training Courses Websphere Online Training Courses Visual Basic Online Training Courses TIBCO SOA Online Training Courses COGNOS Online Training Courses Perl Scripting Online Training Courses Hyperion Online Training Courses Informatica Online Training Courses Python Online Training Courses QlikView Course Contents QA Online Training Courses Tableau Tool Online Training Courses Basic .Net Training Course
More    


SAS 9.2 & 9.3 COURSE CONTENT DETAILS:

 

SAS/BASE

 

BASIC THEORY OF SAS AND Its 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 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

 

 

 

 

 

 

 

 

 


Signup


Name: 

Phone No: 

Email:  

Password: 

Need Resume Preparation:     

 
Select Skills:
select skills and click ok to confirm
 
Select Sub Skills:    
select sub skills and click ok to confirm

Available Time:     (hold Ctrl to select multiple)

Register Now!

Free Demo Class
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.

get free advice
course