Get Unlimited Microsoft Training With Your FastPass - Just £6000! Training Centre Now Open - Offering Residential, OIL and Hybrid Courses.

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 76532 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 at the earliest available opportunity after the course - either immediately after your classroom course, or as soon as there are slots available, if you've taken it online
  • 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 76532 students and asked them all to review our Accelerated Learning. Currently, 96.73% 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.


"I was fairly foreign to most components of the CCNA course. The Firebrand instructor made all parts of the course clear leading to many "AHA!" moments. "
P.L., IBM CLoud. (3/8/2020 (Monday) to 8/8/2020 (Saturday))

"Provided with the appropriate materials to get through the course. Instructor was very knowledgeable and covered all the topics required."
A.H., NHS North of England CSU. (3/8/2020 (Monday) to 8/8/2020 (Saturday))

"The instructor was very knowledgeable about the course material, the course did run very fast which I understand was the point of it so whilst it may have been a bit too fast for me, I appreciate how well the instructor kept on track and taught the class as well as answering the questions"
C.M., i-dash. (3/8/2020 (Monday) to 8/8/2020 (Saturday))

"Excellent course so much in-depth information passed on. Excellent instructor - course was intensive no doubt about it. But will be back later in 2020 for some more education. "
Adele Reed. (3/8/2020 (Monday) to 6/8/2020 (Thursday))

"The course really keyed in all the topics of the exam. The material slides, documentation, labs was well written and presented. The instructor really knew his stuff and you could tell he was passionate about the subject. When also considering the difficult times we live in with COVID-19, the training and the staff were superb."
Chuck Ashmore. (27/7/2020 (Monday) to 31/7/2020 (Friday))

Course Dates

Start

Finish

Status

Location

Book now

25/5/2020 (Monday)

27/5/2020 (Wednesday)

Finished - Leave feedback

-

 

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