SAS

SAS Base & Advance SAS Online Training Course Content

• What is SAS and Basics of SAS

• History Of Sas
• Functionality Of Sas
• Architecture Of Sas
• Sas Program Rules
• File Elements Of Sas
• Sas Names & Rule
• Missing Data
• Types Of Variables
• How Sas System Read Values Into Variables
• Lengths of Variables
• Sas Windowing Environment
• Sas Program & Components Of Sas Program
• Creation Of Libraries
• Member Types
• Datasets
• Views
• Catalogs
• Indexes
• Sas Programming (Briefly)
• Data Step
• Proc Step
• Global Options
• Global Statements
• Backend Process Of SAS Program
• Installation Process
• ETL Concepts

• BEGIN WITH DATASTEP

• Data Step & Purpose of Data Step
• Data Statement & Dataset Options
• Infile Statement & Options
• Input Statement & Types of Input & Options
• Datalines / Cards Statement (or) Datalines4 / Cards4 Statement
• Run Statement / Quit Statement

• ATTRIBUTES OF VARIABLES

• Data Types
• Label Statement
• Length Statement
• Informat Statement
• Format Statement
• How Dates Works In Sas
• System Defined / User Defined Informats & Formats

• OTHER SAS STATEMENTS

• Keep Statement
• Drop Statement
• Rename Statement
• Replace Statement
• Sum Statement
• Retain Statement
• Goto Statement
• Link Statement
• Return Statement
• Output Statement
• Stop Statement

• CONDITIONAL STATEMENTS

• If Statement
• If Then Statement
• If Then Else Statement
• If Then Delete Statement
• If Then Remove Statement
• If Then Output Statement
• If Then Do Statement
• If Then Do While Statement
• If Then Do Until Statement
• If Then Goto Statement
• Where Statement
• Operators
• Arithmetic Operators
• Comparison Operators
• Logical Operators
• Expressions

• LOOPS

• Do Statement
• Do Iterative Statement
• Do While Statement
• Do Until Statement
• End Statement
• Output Statement
• Stop Statement

• ARRAY

• Why Do We Need Arrays?
• Basic Array Concepts
• Array Statement
• Array References
• Variable Name Array Reference
• Using Array Indexes
• One Dimension Arrays&Multi-Dimension Arrays
• Temporary Arrays
• Sorting Arrays
• Determining Array Bounds: Lbound And Hbound Functions
• When To Use Arrays
• Common Errors And Misunderstandings
• Invalid Index Range
• Function Name As An Array Name
• Array Referenced In Multiple Data Steps, But Defined In Only One

• BY – GROUP PROCESSING

• Definitions For By-Group Processing
• By-Group Processing
• Sorting Data (Proc Sort)
• By Value&By Group
• Variable And Last.Variable
• Modifying Sas Data Sets: Examples.
• Invoking By-Group Processing
• Preprocessing Input Data For By-Group Processing
• Sorting Observations For By-Group Processing
• Indexing For By-Group Processing
• How The Data Step Identifies By Groups
• Processing Observations In A By Group
• How Sas Determines First.Variable And Last.Variable
• Processing By-Groups In The Data Step
• Processing By-Groups Conditionally
• Data Not In Alphabetic Or Numeric Order
• Data Grouped By Formatted Values

• COMBINING SAS DATA SETS

• Concatenation
• Interleaving
• Merge
• Update
• Modify

• FUNCTIONS (100 + Functions)

• Character / String Functions
• Numeric Functions
• Date Functions

• REVIEW OF DATASTEP

• SAS – PROCEDURES (PROC STEP)

• What Is Proc Step
• Purpose Of Proc Step
• Types of Procedures

• DATA ACCESS PROCEDURES

• Sql Pass Thru Query (Proc Sql)
• Proc Access
• Proc Dbload
• Libname Facility
• Proc Import
• Proc Export

• UTILITY PROCEDURES

• Proc Contents
• Proc Setinit
• Proc Options
• Proc Pwencode
• Proc Copy
• Proc Delete
• Proc Printto
• Proc Sort
• Proc Compare
• Proc Append
• Proc Datasets
• Proc Format
• Proc Rank
• Proc Transpose
• Proc Template
• Proc Forms
• Proc Catalog
• Proc Cport
• Proc Cimport
• Proc Upload
• Proc Download
• Proc Migrate

• STATISTICS & STATISTICAL PROCEDURES

• Proc Means
• Proc Summary
• Proc Univariate
• Proc Freq
• Proc Corr
• Proc Reg
• Proc Anova
• Proc Glm
• Proc Lifetest
• Proc Lifereg
• Proc Logistics
• Proc Npar1way
• Proc Ttest

• REPORTING PROCEDURES

• Proc Print
• Proc Tabulate
• Proc Report
• Data Step Reporting (_Null_ Reporting)

• GRAPHICAL PROCEDURES

• Proc Gchart
• Proc Gplot
• Proc Sgplot
• Proc Gis
• Proc Gmap

• REVIEW OF PROCSTEP

• ODS (OUTPUT DELIVERY SYSTM)

• SAS DDE (Dynamic Data Exchange)

• DICTIONARY TABLES

• LIST OF GLOBAL STATEMENTS

• LIST OF GLOBAL OPTIONS

• PROC SQL

• INTRODUCTION TO THE SQL PROCEDURE
• RETRIEVING DATA FROM A SINGLE TABLE
• RETRIEVING DATA FROM MULTIPLE TABLES
• CREATING AND UPDATING TABLES AND VIEWS
• PROGRAMMING WITH THE SQL PROCEDURE
• PRACTICAL PROBLEM-SOLVING WITH PROC SQL

• SAS/MACROS

• PERFORMANCE TUNING CONCEPTS

• TESTING & DEBUGGING TECHNIQUES

• ERROR HANDLING

• FEATURES BETWEEN SAS VERSIONS V9

• SAS WITH UNIX/LINUX ENVIRONMENT