SAS® Certification Review: SAS® 9.4 Base Programming Performance-Based Exam

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

• 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

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

Access and Create Data Structure

• 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

Manage Data

• 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

Error Handling

• Identifying and resolving programming logic errors
• Examining and resolving data errors

Generating Reports and Output

• 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

Additional Information

• More specifics about the SAS 9.4 Base Programming Performance-Based Exam
• Additional preparation resources
• Test-taking strategies