Session : 1 – Overview of SAS

• Introduction and History of SAS
• Significance of SAS software solutions in various industries
• Demonstrate SAS Capabilities
• Job Profile / career opportunities with SAS worldwide?

Session : 2 – Base SAS Fundamentals

• Explore SAS Windowing Environment
• SAS Tasks
• Working with SAS Syntax
• Create and submit a SAS sample program

Session : 3 – Data Access & Data Transformation

• Accessing SAS Data libraries
• Getting familiar with SAS Data set

Session : 4 – Reading SAS data set

• Introduction to reading data
• Examine structure of SAS data set
• Understanding of SAS works

Session : 5 – Reading Excel worksheets

• Using Excel data as input
• Create as sample program to import and export excel sheets

Session : 6 – Reading Raw data from External File

• Introduction to raw data
• Reading delimited raw data file (List Input)
• Using standard delimited data as input
• Using nonstandard delimited data as input
• Reading raw data aligned to columns (Fixed or column input)
• Reading raw data with special instructions (Formatted input)

Session : 7 – Writing to an External file

• Write data values from SAS data set to an external file

Session : 8 – Data transformations (Data step processing)

• Create multiple output datasets from single SAS dataset
• Writing observations to one or more SAS datasets
• Controlling which observations and variables to be written to output data

Session : 9 – Creating subset of observations using

• Where condition
• Conditional processing using: IF statements

Session : 10 – Processing Data Iteratively

• Iterative DO loop processing with END statement
• DO WHILE & DO UNTIL Statement
• SAS Array statement

Session : 11 – Summarizing data

• Creating and Accumulating total variable (Retain)
• Using Assignment statement
• Accumulating totals for a group of data (BY group)

Session : 12 – Manipulating Data

• Sorting SAS data sets
• Manipulating SAS data values
• Presentation of user defined values /data/currency values using FORMAT procedure
• SAS functions to manipulate char and num data
• Convert data type form char-to num and num-to-char
• SAS variables lists/ SAS variables lists range
• Debugging SAS program
• Accessing observations by creating index

Session : 13 – Restructuring a SAS data set

• Rotating with the data step
• Using the transpose procedure

Session : 14 – Combining SAS data sets

• Concatenation
• Interleaving
• One to one reading
• One to one merging (with non-matching)
• Match merging (Merging types with IN=option)

Session : 15 – SAS Access & SAS Connect

• Validating and cleaning data
• Detect and correct syntax errors
• Examining data errors

Session : 16 – Analysis & Presentation

Session : 17 – SAS/REPORTS SAS/GRAPH

Session : 18 – SAS/STATS SAS/ODS

Session : 19 – Producing detailed /Summary Reports

• Freq Report
• Means Report
• Tabulate Report
• Proc report
• Summary report
• Univariate report
• Contents report
• Print report
• Compare proc
• Copy proc
• Datasets proc
• Proc append
• Proc delete

Session : 20 – Generating Statistical Reports using

• Regression proc
• Uni/Multivariate proc
• Anova proc

Session : 21 – Generating Graphical reports using

• Producing Bar and Pie charts (GCHART Proc)
• Producing plots (GPLOT Proc)
• Presenting Output Report result in:
• PDF
• Text files
• Excel
• HTML Files

Session : 22 – SAS/SQL Programming

• Introduction and overview to SQL procedure
• Proc SQL and Data step comparisons

Session : 23 – Basics Queries

• Proc SQL syntax overview
• Specifying columns/creating new columns
• Specifying rows/subsetting on rows
• Ordering or sorting data
• Formatting output results
• Presenting detailed data
• Presenting summarized data

Session : 24 – Sub Queries

• Non correlated sub queries
• Correlated sub queries

Session : 25 – SQL Joins (Combining SAS data sets using SQL Joins)

• Introduction to SQL joins
• Types of joins with examples
• Simple to complex joins
• Choosing between data step merges and SQL joins

Session : 26 – SET Operators

• Introduction to set operations
• Except/Intersect/Union/Outer union operator

Session : 27 – Additional SQL Procedures features

• Creating views with SQL procedure
• Dictionary tables and views
• Interfacing Proc SQL with the macro programming language
• Creating and maintaining indexes
• SQL Pass-Through facility

Session : 28 – SAS Macro Language

• Introduction to macro facility
• Generate SAS code using macros
• Macro compilation
• Creating macro variables
• Scope or macro variables
• Global/Local Macro variables
• User defined /Automatic Macro variables
• Macro variables references
• Combing macro variables references with text
• Macro functions
• Quoting (Masking)
• Creating macro variables in Data step (Call SYMPUT Routine)
• Obtaining variable value during macro execution (SYMGET function)
• Creating macro variables during PROC SQL execution (INTO Clause)
• Creating a delimited list of values
• Macro parameters
• Strong Macro using Autocall Features
• Permanently storing and using stored compiled macro program
• SAS Macro debugging options to track problems

Session : 29 – Basics Statistics

• Standard deviation
• Correlation Coefficients
• Outliers
• Linear regressions
• Clustering
• Chi Square