SAS Course Info                                                             

   SAS (Statistical Analysis System) is a software suite developed by

SAS Institute for advanced analytics, business intelligence, data management, and predictive

Analytics. It is the largest market-share holder for advanced analytics.

SAS is a software suite that can mine, alter, manage and retrieve data from a variety of sources and Perform statistical analysis on it. SAS provides a graphical point-and-click user interface for nontechnical Users and more advanced options through the SAS programming language. SAS programs Have a DATA step, which retrieves and manipulates data, usually creating a SAS data set, and a PROC step, which analyzes the data.

Course Content

A Brief introduction to SAS

 Introduction

 The Microsoft Windows User Interface

 The Editor Window

 The Log window

 Output Window

 Explorer Window

 Results Window


Base SAS

Options:

System options:

 Center / nocenter                                         Stimer

 Date/nodate                                                   FullStimer

 Number/Nonumber                                 FormChar

 Caps/Nocaps                                         Xwait/Noxwait

 Notes/Nonotes                                         Xsync

 Labels/Nolabels                                         Fmterr

  Yearcuttoff                                                    Buff no

 Buffsize                                                 Errorabend

 Formdlim                                                 Errors

 Pageno                                                 Pagesize

 Lrecl                                                            Linesize

 Missing                                                 skip

 Replace

The Data Step Options

Variable Control options:

 Keep

 Drop

 Rename

Observation Control Options:

 Firstobs

 obs

 Where

Dataset Control Options:

 Label

 PW(Password)

 Replace

Proc Step Options

 Title

 Footnote

 Noobs

 Double

 Where

Statement Options

1) Local Statement

2) Global Statement

1) Local Statements:

 Set

 Interleaving

 Control (If Then Else & If then Do)

 Update

 Modify

 Location

 Length

 Sum

 Put

 Retain

 Arrays

Infile

2).Global Statements:

 By

 Where

 Label

 Attrib

Introduction about SAS libraries

 Creating A Permanent Library:

 Wizard Method

 Syntax Method

Type of Input Methods:

 List Input

 Column Input

 Named input

 Formatted Input

 Mixed Input

 Modifier

Pointers In SAS:

 Line Pointers (observation Pointers)

Column Pointers (Variable Pointers)  

Introduction To Formats And Informats:

 Date formats & Informats

 Character Informats & Formats

 Numeric Informats & Formats

Functions:

 Character Function

 Statistical Functions

 Date Functions

 Mathematical & Numerical Functions

Introduction To SAS Procedure:

 Proc Setinit

 Proc Options

 Proc Import

 Proc export

 Proc Contents

 Proc sort

 Proc append

 Proc format

 Proc compare

 Proc transpose

 Proc copy

 Proc datasets

 Proc catalog

 Proc upload

 Proc download

 Proc tabulate

 Proc report

 Proc MDDB

 Proc C port

 Proc C Import

 Proc delete

 Proc document

Statistical procedures:

 Proc univariate

 Proc means

 Proc summary

 Proc Rank

 Proc Freq/chisquare

 Proc Anova

 Proc Glm

 Proc reg

 Proc T test

 Proc corr

 Proc logistic

Introduction to SAS Output Delivery System (ODS)

 Concepts of the Output Delivery system

 Tracing and Selecting procedure Output

 Creating SAS datasets from procedure Output

 Using ODS statements to create HTML output

 Using ODS statements to create PDF output

 Using ODS statements to create RTF output

 Using ODS statements to create PS output

 Using of ODS trace on and trace off statements

 Using of ODS select statement

 Concept of ODS TAGSETS

Introduction to SAS/Graph (Graphical Representation)

1) Proc Gchart

Vbar

Hbar

Pie

Star

Block

Vbar3d

Hbar3d

Pie3d

Donut

2) Proc Plot

3) Proc G plot

SAS/Connect (Explanation on Different Database oracle, DB2, Teradata)

1)Direct Mode Connectivity

2)Indirect Mode Connectivity

SAS/Access:

 Interface to the RDBMS

 Direct Method:

1) Libname Facility

2) Passthrough Facility(PTF)

1) Proc DB load

2) Proc Access

Advance Programming In SAS:

 SAS/Macros

 SAS/Sql

SAS/Macros:

Introduction on Macros:

Macro Compilation (Explanation diff b/w Base sas and Macros)

Creation Macro Variable (System defined/Userdefined Libraries)

Macro definition

Macro Functions (Macro Compile/Execution Functions)

Macro Debug Options

Auto call Macros/Stored Macros

SAS/SQL:

 Introduction to SAS/SQL

 Proc SQL

 Proc SQL Statement

 Concepts of DDL Commands

 Concepts of DML Commands

 Concepts of DQL/DRL Commands

 Concepts of DCL/TCL Commands

 Concept of Validate Statement

 Describe statement

 Coalesce function

 Upper function

 Order by & group by clauses

JOINS

 Reflexive jobs

 Inner Joins

 Outer Joins

 Normal Joins

 Natural Joins

 Cross Join

 Union Joins

OPERATORS

 Union all

 Intersect

 Except

Creation of Index/Views

DEBUGGING TECHNICS IN SAS PROGRAMS

 Proc Print Writing SAS programs that work

 Proc Contents Writing SAS programs that don’t work

 Proc Append Searching for missing semicolon

 Proc Compare Lost card

 Proc Options Invalid Data

 Proc Datasets Numeric Values have been converted

 Proc Format to Character and vice-versa

RCP Technologies Pvt Ltd , # 302, Annapurna Block, Aditya Enclave Ameerpet, Hyderabad -16     Helpline:9989134470