Unlimited Microsoft Training for £6,600 with Microsoft FastPass!
Only 3 days
Classroom
14/10/2024 (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.
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
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)
Benefits
Seven reasons why you should sit your course with Firebrand Training
- Two options of training. Choose between residential classroom-based, or online courses
- You'll be certified fast. With us, you’ll be trained in record time
- Our course is all-inclusive. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
- Pass the first time or train again for free. This is our guarantee. We’re confident you’ll pass your course the first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
- You’ll learn more. A day with a traditional training provider generally runs from 9 am – 5 pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day of quality learning time, with your instructor
- You’ll learn 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
- You’ll be studying with the best. We’ve been named in the 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 over 135,000 professionals
- For residential training only. Doesn't apply for online courses
** Some exceptions apply. Please refer to the Exam Track or speak with our experts
Think you are ready for the course? Take a FREE practice test to assess your knowledge! Free Practice Test