SAS Training

SAS Training

SAS is a statistical analysis tool that is used in niche industries like pharmaceutical, banking etc. Although this is a general purpose data warehousing and reporting tool, this tool is specifically built to the special needs of certain industries.

Additional Freebies – Along with the training we provide the following additional services.

1. One Month of SAS support (After training, During the practice).
2. Mock Interviews.
3. Interview Tips.
4. Resume Marketing

Intended Audience – SAS is intended for any of the following audience.

1. Experienced Business Users who have been working extensively in Statistical Analysis.
2. Less than 1 yr of experience in SAS and wish to further renew his/her skills.

Table of Contents

Base SAS

(Week 1 )

• Introduction to SAS Programming
• Working in the SAS Environment
• Working with the Windows
  • Enhance Editor
  • Result Window
  • Log Window
  • Explorer Window
  • Output Window
  • Program Editor Window
• Overview of Libraries
  • Data Sets
  • Cube
  • Data View
  • Referencing Files in Catalog
  • SAS Libraries

Base SAS .. Continued

( Week 2 )

• Basic Concepts
  • Creating a SAS Program
  • Components of SAS Program
  • Characteristics of SAS Program
  • Layout of SAS Program
• Understanding Data Step Processing
  • Program Data Vector
  • Execution Phase
  • Compilation Phase
  • Creating File Shortcuts
  • Browsing and submitting file shortcuts for SAS Program
  • Get Started with Output Delivery System ( ODS )
• Global & Local Options.

• Statements
  • Global Statements
  • Local Statements
• Input Styles
  • List Input
  • Modified Input
  • Column Input
  • Named Input
  • Formatted Input

Base SAS.. Continued

( Week 3 )

• Pointers
  • Column Pointers
  • Line Pointers
• Formats
  • Numeric
  • Character
  • Date & Time
• Combining SAS Data Sets
  • Concatenation
  • One-One Merging
  • Interleaving
  • Match Merging
  • One-One Reading
  • Updating or Setting
• Controlling Statements
  • IF & IF THEN statement
  • IF ELSE statement
  • Where condition
  • Like , Into Statements
  • Loops ( Do, While )
  • Arrays

Base SAS .. Continued

(Week 4 )

• Reading Raw data from External Files
  • Infile Statement
  • File Name Statement
  • DDE Triplet
• Writing Data to External Files
  • File Statement
  • Put Statement
• Output Delivery System
  • Fundamentals of ODS
  • ODS in Data step
  • Syntax for the ODS and enhanced features in Data Step
• Debugging
  • Checking for Errors, Warnings, Un-Initialization , missing values
• Procedures
  • Proc Sort
  • Proc Transpose
  • Proc Print, Proc Printto,
  • Proc Catalog, Proc Contents
  • Proc Formats, Proc Compare
  • Proc Append, Proc Tabulate
  • Proc Options, Proc Report
  • Proc Import, Proc Export
  • Proc Freq
  • Proc Means
  • Proc Chart
  • Proc Datasets
  • Proc Access
  • Proc Summary

SAS Macos & SAS SQL

( Week 5 )

• SAS Macros
  • Introduction to SAS Macro Language Elements
  • Introduction to Macro Variables
  • Automatic Macro Variables
  • User define Macro Variables
  • How Macro processing will undergo inside the SAS system
  • Macro Statements
  • Macro Functions
  • Autocall Macros
• SAS SQL
• • Introduction to Proc SQL
  • Creating Tables
  • Inserting data into Tables
  • Alter & update the tables
  • SQL pass through Facility
  • Connecting to DBMS
  • Natural Joins
  • Inner Joins
  • Outer Joins

SAS Access, Connect and STAT

( Week 6 )

• SAS ACCESS and SAS CONNECT
• SAS GRAPH
  • Type of Graphs
  • Different Options used in graphs
• SAS/STAT
  • Proc Correlation
  • Proc Univariate
  • Proc Regression
  • Proc Anova