• Learning Base SAS Programming

    Basic Concepts

    • Introduction to SAS tool
    • SAS Libraries /Temporary Library/ Permanent Library
    • Creating Libraries
    • Start with a Basic SAS programs
    • Data Step / Proc Step / Statements/ Global statements
    • Variables / Datatypes / properties of Variables

    Access Data

    • INFILE statement options to read raw data files
    • Creating a file refrence with filename statement
    • DATALINES statement with an INPUT statement

    Starting With Raw Data(Basics)

    • Styles of Input
    • Reading Unaligned Data / Understanding List Input
    • Understanding Column Input / Reading Data Aligned in Columns

    Formats and Informats

    • Standard Data/ Non Standard Data
    • How Informats and Format works
    • Working with Date/Time/Datetime informat
    • How and when to use Yearcutoff

    Starting With Raw Data( Beyond Basics)

    • Formatted Input style
    • Using Modifiers

    Mixing Styles of Input

    • Testing a Condition before Creating an Observation
    • Creating Multiple Observations from a Single Record
    • Reading Multiple Records to Create a Single Observation

    PDV: How the DATA Step Works

    • Writing Basic Data Step
    • How SAS Processes Programs
    • Compilation phase
    • Execution Phase
    • Debugging a Data Step
    • Testing SAS Programs

    Manipulating SAS Datasets

    • Creating & Modifying Variables ()
    • Assigning Values Conditionally
    • Specifying Lengths for Variables
    • Subsetting Data
    • Assigning Permanent Labels and Formats

    Grouping Statements Using DO Groups

    • Assigning Values Conditionally Using SELECT Groups
    • Reading a Single Data Set
    • Manipulating Data
    • Using BY-Group Processing
    • Reading Observations Using Direct Access (Point= option)
    • Detecting the End of a Data Set(end= option)
    • Understanding How Data Sets Are Read through PDV
    • Renaming Variables
    • Selecting Variables

    Combining SAS Data Sets

    • One-to-One Reading
    • Concatenating
    • Interleaving
    • Match-Merging
    • Match-Merge Processing
    • Excluding Unmatched Observations

    Transforming Data with SAS Functions

    • General Form of SAS Functions
    • Converting Data with Functions
    • Restriction for WHERE Expressions
    • Manipulating SAS Date Values with Functions
    • SAS Date and Time Values
    • SAS Date Functions
    • Modifying Character Values with Functions
    • Modifying Numeric Values with Functions
    • Nesting SAS Functions

    RELEVANT BASE SAS PROCEDURES:

    • APPEND PROCEDURE
    • SORT PROCEDURE
    • DATASETS PROCEDURE
    • PRINTTO PROCEDURE
    • FORMAT PROCEDURE
    • TRANSPOSE PROCEDURE
    • IMPORT PROCEDURE
    • EXPORT PROCEDURE
    • PRINT PROCEDURE
    • TABULATE PROCEDURE
    • REPORT PROCEDURE
    • MEANS PROCEDURE
    • SUMMARY PROCEDURE
    • FREQ PROCEDURE

    Generating Data with DO Loops

    • Constructing DO Loops
    • Introduction to Constructing DO Loops
    • DO Loop Execution
    • Counting Iterations of DO Loops
    • Decrementing DO Loops
    • Nesting DO Loops
    • Iteratively Processing Data That Is Read from a Data Set
    • Conditionally Executing DO Loops
    • Using Conditional Clauses with the Iterative DO Statement
    • Creating Samples

    Processing Variables with Arrays

    • Creating One-Dimensional Arrays
    • Understanding SAS Arrays
    • Defining an Array
    • Variable Lists as Array Elements
    • Referencing Elements of an Array
    • Compilation and Execution
    • Using the DIM Function in an Iterative DO Statement
    • Creating Variables in an ARRAY Statement
    • Creating Temporary Array Elements
  • Learning Advance SAS programming

    SQL Processing with SAS

    • Performing Queries Using PROC SQL
    • Combining Tables Horizontally Using PROC SQL
    • Combining Tables Vertically Using PROC SQL
    • Creating and Managing Tables Using PROC SQL
    • Managing Processing Using PROC SQL

    SAS Macro Language

    • Introducing Macro Variables
    • Processing Macro Variables at Execution Time
    • Creating and Using Macro Programs
    • Storing Macro Programs

    Advanced SAS Programming Techniques

    • Combining Data Vertically
    • Combining Data Horizontally
    • Using Lookup Tables to Match Data
    • Formatting Data
    • Modifying SAS Data Sets and Tracking Changes

TAG: Best SAS Certification Training In Delhi | Base SAS | Advance SAS