About this course

Course code TPCERT94
Duration 5 Days

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.

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.

Who should attend?

  • Anyone wanting to take the SAS Certified Base Programmer Exam

Delegates will 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

Outline

Introduction

  •  Information about the SAS®9 Base Programming Exam
  •  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

Reading SAS Data Sets

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

Reading Spreadsheet and Database Data

  •  reading spreadsheet data
  •  reading database data

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
  •  creating user-defined formats
  •  subsetting and grouping observations
  •  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)
  •  creating raw data files (self-study)

Data Transformations

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

Debugging Techniques (optional)

  •  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

Creating Reports with the REPORT Procedure (Self-study)

  •  creating reports with the REPORT procedure

Learning More

  •  SAS resources
  •  beyond this course

5 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.