Base SAS/Advanced SAS

        BASE SAS 

• Introduction to SAS System
• Features of SAS
• Accessing the SAS System
• SAS programming windows
• Syntax of SAS Programming
• Writing, Submitting the Program
• Checking the SAS log for Program errors/warnings/notes
• Handling Program errors/warnings/notes
• Checking the program’s output
• Understanding data sets, variables, and observations
• Programming Data Vector
• Reading Raw Data
• Infile Statements with Options
• Understanding DATA and PROC Steps
• Concepts/Types/Accessing SAS Libraries
• Accessing the data- Formatted/List/Columns
• Creating Variables and Reading the SAS data sets
• SAS Data Set Statements/Options
• Conditional Statements if-else/if then else/Where/do loop
• Selecting Variables and Observations
• Accessing the data and Writing to external files
• Converting variables types
• SAS functions
• Combining SAS Datasets
• Generating the reports
• Enhancing the report by using the labels/titles/footnotes
• Generating HTML reports using ODS Statements
• Display Manager Commands
• Procedures Discussion

          Advanced SAS 

   Proc SQL

• Introduction to SAS/SQL
• Advantages of Proc SQL
• Proc SQL Terminology
• Group by/Order By/Having Clause
• Functions
• Conditional Statements
• Creating and Deleting Tables
• Sub Queries /Sub Queries
• Joins & Views

   SAS/MACROS

• Advantages of Macros
• Macro Concepts
• Macro Processing
• Creation of Macros/Macro variables
• Usage Macro Variables
• Invoking A Macro
• Macro Functions
• Macros with Conditional Statements
• Local and Global Macros