Base SAS Programming

Course code : SASPB1

Duration        : 30 Hours

Build a strong SAS programming foundation to manipulate your data, perform complex queries and simple analyses, and generate reports. Gain the knowledge needed to become certified as a Base SAS programmer.

Audience

  • Those who have a need to learn and perform SAS programming
  • Candidates aspiring for a career in SAS analytics
  • Candidates aspiring for obtaining SAS Base certification
  • Candidates aspiring to embark on learning advanced topics in SAS programming
  • Prerequisites

    No prerequisite is required. Knowledge in working on computers and understanding data file structures of operating system is required.

    Objective

  • Understand foundation SAS
  • Ability to use SAS windowing environment
  • Ability to use SAS enterprise guide programming environment
  • Ability to use SAS libraries
  • Ability to access data sets and relational databases
  • Ability to define input and output data sets
  • Create SAS variables and subset data
  • Combine SAS data sets
  • Use conditional and iterative statements in programming
  • Use array processing
  • Transform data, character and numeric data
  • Generate and validate reports
  • Identify and resolve data, syntax and programming errors
  • Course Overview

    • Course outline
    • Course objectives
    • An overview of exercises and case study

    PART 1 Programming Essentials

    • Overview of SAS software and its application in business today
    • Overview of SAS software and tools and their functional implementation
    • Introduction to SAS Program
    • Submitting SAS Program
    • Working with SAS syntax
    • Examining Descriptor and Data portions
    • Accessing SAS Data Libraries
    • Accessing Relational Database
    • Lab exercises

    PART 2 Accessing Data

    • Use FORMATTED and LIST input to read raw data files
    • Use INFILE statement options to control processing when reading raw data files
    • Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls
    • Combine SAS data sets
    • Access an Excel workbook
    • Lab exercises

    PART 3 Creating Data Structures

    • Create temporary and permanent SAS data sets
    • Create and manipulate SAS date values
    • Export data to create standard and comma-delimited raw data files
    • Control which observations and variables in a SAS data set are processed and output
    • Lab exercises

    PART 4 Managing Data

    • Investigate SAS data libraries using base SAS utility procedures
    • Sort observations in a SAS data set
    • Conditionally execute SAS statements
    • Use assignment statements in the DATA step
    • Modify variable attributes using options and statements in the DATA step
    • Accumulate sub-totals and totals using DATA step statements
    • Use SAS functions to manipulate character data, numeric data, and SAS date values
    • Use SAS functions to convert character data to numeric and vice versa
    • Process data using DO LOOPS
    • Process data using one-dimensional SAS arrays
    • Validate and clean data
    • Lab exercises

    PART 5 Generating Reports

    • Generate list reports using the PRINT procedure
    • Generate summary reports and frequency tables using base SAS procedures
    • Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting
    • Generate reports using ODS statements
    • Lab exercises

    PART 6 Handling Errors

    • Identify and resolve programming logic errors
    • Recognize and correct syntax errors
    • Examine and resolve data errors
    • Lab exercises

    PART 7 Case Study and Project work

    • Implementing lessons learnt so far to a real-world application

    Course Review

    Exam Preparation (Optional)