support & services / Education

SAS Certified Base Programmer Fast Track – CERT92

This course teaches the fundamentals of SAS – data access, manipulation, analysis and reporting – and has been designed to prepare learners for the SAS Certified Base Programmer exam.

Download course description as PDF  Register now 

Duration

5 Days - Classroom

Learn how to

The SAS Certified Base Programmer is responsible for analysing and presenting data to solve business needs. A base programmer should be able to:

  • understand file structure and write system commands to create and access files
  • understand programming logic concepts (IF/THEN logic)
  • understand the compilation and execution process of the DATA step
  • use different kinds of input to create SAS data sets from external files
  • use SAS software to access SAS data libraries
  • create and use SAS date values
  • read, concatenate, merge, match-merge and interleave SAS data sets
  • use the data set options DROP=, KEEP= and RENAME=
  • create multiple output data sets
  • use array processing and DO loops to process data iteratively
  • use SAS functions to perform data manipulation and transformations

Who should attend?

Anyone wanting to take the SAS Certified Base Programmer Exam

Prerequisites

Before attending this course, you should have:

  • an understanding of your operating system
  • some experience of programming in other languages or packages would be advantageous
  • No prior SAS experience is needed.

Course Contents

Introduction

  • course logistics
  • overview of Foundation SAS

Getting Started with SAS

  • introduction to SAS programs
  • submitting a SAS program

Working with SAS Syntax

  • mastering fundamental concepts
  • diagnosing and correcting syntax errors

Getting Familiar with SAS Data Sets

  • examining descriptor and data portions
  • accessing SAS data libraries
  • accessing relational databases (self-study)

Reading SAS Data Sets

  • introduction to reading data
  • using SAS data as input
  • subsetting observations and variables
  • adding permanent attributes

Reading Excel Worksheets

  • using Excel data as input
  • doing more with Excel worksheets (self-study)

Reading Delimited Raw Data Files

  • using standard delimited data as input
  • using nonstandard delimited data as input

Manipulating Data

  • creating variables
  • creating variables conditionally
  • subsetting observations

Combining SAS Data Sets

  • introduction to combining data sets
  • appending a data set (self-study)
  • concatenating data sets
  • merging data sets one-to-one
  • merging data sets one-to-many
  • merging data sets with nonmatches

Producing Summary Reports

  • using the FREQ procedure
  • using the MEANS procedure
  • using the TABULATE procedure (self-study)

Enhancing Reports

  • using global statements
  • adding labels and formats (self-study)
  • creating user-defined formats
  • subsetting and grouping observations (self-study)
  • directing output to external files

Controlling Input and Output

  • outputting multiple observations
  • writing to multiple SAS data sets
  • selecting variables and observations

Summarising Data

  • creating an accumulating total variable
  • accumulating totals for a group of data

Reading Raw Data Files

  • reading raw data files with formatted input
  • controlling when a record loads
  • additional techniques for list input (self-study)

Data Transformations

  • manipulating character values
  • manipulating numeric values
  • converting variable type

Debugging Techniques (self-study)

  • using the PUTLOG statement
  • using the DEBUG option

Processing Data Iteratively

  • DO-loop processing
  • SAS array processing
  • using SAS arrays

Restructuring a Data Set

  • rotating with the DATA step
  • using the TRANSPOSE procedure

Learning More

  • SAS resources
  • beyond this course

Software Addressed

Base SAS

Book Your Place Today