SAS® Certification Review: SAS® 9.4 Base Programming Performance-Based Exam
4h 9m + Hands-On Practice
Available in:
SAS® Certification Review: SAS® 9.4 Base Programming Performance-Based Exam
CRB : CRBM8
This course provides a review of the majority of topics in the SAS 9.4 Base Programming Performance-Based Exam. It addresses the four exam content areas: Accessing and Creating Data Structures, Managing Data, Generating Reports and Output, and Handling Errors.
Learn How To
- Read, create, and combine SAS data sets.
- Sort observations with the SORT procedure.
- Read delimited data and Microsoft Excel files with the IMPORT procedure and the LIBNAME engine.
- Create variables using assignment, conditional, and sum statements.
- Manipulate data using SAS functions.
- Process data with DO loops.
- Restructure data with the TRANSPOSE procedure.
- Create reports using the PRINT procedure, the FREQ procedure, the MEANS procedure, and the UNIVARIATE procedure.
- Create formats with the FORMAT procedure.
- Create external files with ODS, the EXPORT procedure, and the LIBNAME engine.
- Identify and resolve programming logic errors.
Who Should Attend
SAS users who are interested in a review course before taking the SAS 9.4 Base Programming Performance-Based Exam, part of the SAS Global Certification Program
Prerequisites
Before attending this course, you should:
- Be an experienced programmer with knowledge of the four exam content areas.
- Have taken SAS Programming 1: Essentials and SAS Programming 2: Data Manipulation Techniques or have equivalent experience.
SAS Products Covered
Base SAS;SAS/ACCESS
Course Outline
SAS 9.4 Base Programming Performance-Based Exam Review
- Specifics about the SAS 9.4 Base Programming Performance-Based Exam.
- Specifics about this review course.
- Review SAS fundamental concepts.
- Using macro variables to simplify code maintenance.
- Investigating SAS data libraries.
- Accessing SAS data sets and data sources not in SAS (Microsoft Excel and text files).
- Creating SAS data sets and reviewing DATA step processes.
- Controlling rows and columns to process and output.
- Modifying column attributes.
- Using assignment statements.
- Conditional processing with IF-THEN/ELSE.
- Sorting and combining tables.
- Accumulating subtotals and totals.
- Manipulating data with functions.
- Iterative processing with DO loops.
- Restructuring data with PROC TRANSPOSE.
- Identifying and resolving programming logic errors.
- Examining and resolving data errors.
- Generating list reports using the PRINT procedure.
- Generating summary reports and frequency tables using Base SAS procedures.
- Enhancing reports with labels, SAS formats, user-defined formats, titles, footnotes, and SAS reporting options.
- Generating reports using ODS statements.
- Exporting data to text and Microsoft Excel files.
- More specifics about the SAS 9.4 Base Programming Performance-Based Exam.
- Additional preparation resources.
- Test-taking strategies.
Live Class Schedule
Duration: 14 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
Live Class Schedule
SOLD SEPARATELY
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.
This course helps prepare you to earn the following SAS Credentials:
SAS Certification Manager
SAS partners with Pearson VUE to provide you with the best possible certification experience.
Certification Resources
