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


 The Microsoft Windows User Interface

 The Editor Window

 The Log window

 Output Window

 Explorer Window

 Results Window

Base SAS


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


The Data Step Options

Variable Control options:




Observation Control Options:




Dataset Control Options:




Proc Step Options






Statement Options

1) Local Statement

2) Global Statement

1) Local Statements:



 Control (If Then Else & If then Do)










2).Global Statements:





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


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


 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










2) Proc Plot

3) Proc G plot

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

1)Direct Mode Connectivity

2)Indirect Mode Connectivity


 Interface to the RDBMS

 Direct Method:

1) Libname Facility

2) Passthrough Facility(PTF)

1) Proc DB load

2) Proc Access

Advance Programming In SAS:




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


 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


 Reflexive jobs

 Inner Joins

 Outer Joins

 Normal Joins

 Natural Joins

 Cross Join

 Union Joins


 Union all



Creation of Index/Views


 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