Summer of Learn: when booking two courses before July 31, save 50% on the second one.
Bright days ahead: our UK training centre has reopened.

SAS - Certified Base Programmer: Fast Track

Duration

Duration:

Only 3 Days

Method

Method:

Classroom / Online / Hybrid

Next date

Next date:

28/9/2020 (Monday)

Overview

On this 3 day accelerated SAS® Base Programmer course, you'll learn the fundamentals of SAS including data access, manipulation, analysis and reporting.

You'll be immersed in the Certified Base Programmer Fast Track curriculum through our unique Lecture | Lab | Review technique, which allows you learn and retain information faster than traditional courses.

On this official SAS course, you'll understand file structures and how to write system commands to create and access files as well as (IF/THEN) principle programming logic concepts. Our expert instructors will also take you through how to:

  • 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

You'll benefit from 24-hour lab access, allowing you to practice and apply your knowledge whenever you want!

During the course, you'll prepare for and sit the SAS Certified Base Programmer exam. Don't pass the first time? Don't worry - you'll be covered by our Certification Guarantee.

This course is ideal for you if you are interested in learning about SAS and becoming a Certified Base Programmer.

Seven reasons why you should sit your course with Firebrand Training

  1. Two options of training. Choose between residential classroom-based, or online Certified Base Programmer courses
  2. You'll be Certified Base Programmer certified in just 3 days. With us, you’ll be Certified Base Programmer trained in record time
  3. Our Certified Base Programmer course is all-inclusive. A one-off fee covers all course materials, exams, accommodation and meals. No hidden extras
  4. Pass Certified Base Programmer first time or train again for free. This is our guarantee. We’re confident you’ll pass your course first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
  5. You’ll learn more. A day with a traditional training provider generally runs from 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day quality learning time, with your instructor
  6. You’ll learn Certified Base Programmer faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
  7. You’ll be studying Certified Base Programmer with the best. We’ve been named in Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified 75966 professionals, and we’re partners with all of the big names in the business

Benefits

Benefits of Training with Firebrand

  • Two options of training - Residential classroom-based, or online courses
  • A purpose-built training centre – get access to dedicated Pearson VUE Select facilities
  • Certification Guarantee – pass first time or train again free (just pay for accommodation, exams and incidental costs)
  • Everything you need to certify – you’ll sit your exam on the course and return home certified
  • No hidden extras – one cost covers everything you need to certify

Curriculum

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

Exam Track

During the course, you'll sit the following exam at Firebrand's Training Centre. Covered by your Certification Guarantee:

SAS® Base Programming for SAS®9 exam

  • Duration: 110 minutes
  • Format: 60-65 multiple-choice and short-answer questions
  • Passing score: 70%

What's Included

On this accelerated course, you'll receive:

  • Official SAS courseware
  • Base SAS Programming case study

Your accelerated course includes:

  • Accommodation *
  • Meals, unlimited snacks, beverages, tea and coffee *
  • On-site exams **
  • Exam vouchers **
  • Practice tests **
  • Certification Guarantee ***
  • Courseware
  • Up-to 12 hours of instructor-led training each day
  • 24-hour lab access
  • Digital courseware **
  • * For residential training only. Doesn't apply for online courses
  • ** Some exceptions apply. Please refer to the Exam Track or speak with our experts
  • *** Pass first time or train again free (just pay for accommodation, exams and incidental costs)

Prerequisites

Before attending the course, you should have:

  • An understanding of operating systems
  • Some experience in programming (you don't need to have experience with SAS)

Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.

Reviews

Here's the Firebrand Training review section. Since 2001 we've trained exactly 75966 students and asked them all to review our Accelerated Learning. Currently, 96.74% have said Firebrand exceeded their expectations.

Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.


"Course was very good, I liked the analogies given to explain complex networking areas it really helped. The instructor was very good at bringing information to a level everyone could understand and then further on that. "
Ewan jamieson, Mr. (17/2/2020 (Monday) to 22/2/2020 (Saturday))

"Knowledgeable, well spoken and relatable instructor. The instructor explained difficult concepts clearly and provided good examples to help us understand the material. He also discussed real-world examples to help solidify how the concepts are applied in the field. There were a few technical issues with the remote learning and remote labs, but overall a great experience, especially so when considering the current situation with COVID-19."
JE, Mitchells & Butlers. (4/5/2020 (Monday) to 7/5/2020 (Thursday))

"I would highly recommend taking up a course with Firebrand because the way the course is delivered is very helpful and useful for someone who either has no knowledge or some knowledge. The instructors do everything they can to ensure everyone is learning and is always on hand to help anyone who is struggling with anything. Everyone on the course is also very helpful and in the same position as they want to learn to. So there is not just the instructor but the class as a whole to assist. The facility is very nice and I will definitely be coming back for any future courses I attend. "
CP, Innovate Ltd. (4/5/2020 (Monday) to 7/5/2020 (Thursday))

"Firebrand have very passionate instructors."
Anonymous (4/5/2020 (Monday) to 7/5/2020 (Thursday))

"Extremely useful course, detailed understanding and trainer had good grasp on the information and was able to explain it in different ways to help our understanding and help us to relate this to our own working environment."
SA, Lloyds Banking Group. (4/5/2020 (Monday) to 6/5/2020 (Wednesday))

Course Dates

Start

Finish

Status

Location

Book now

25/5/2020 (Monday)

27/5/2020 (Wednesday)

Finished

-

 

28/9/2020 (Monday)

30/9/2020 (Wednesday)

Wait list

Nationwide

 

9/11/2020 (Monday)

11/11/2020 (Wednesday)

Limited availability

Nationwide

 

21/12/2020 (Monday)

23/12/2020 (Wednesday)

Open

Nationwide

 

1/2/2021 (Monday)

3/2/2021 (Wednesday)

Open

Nationwide

 

15/3/2021 (Monday)

17/3/2021 (Wednesday)

Open

Nationwide

 

Latest Reviews from our students