SAS Programming Intermediate (Test-Prep for the SAS Associate and SAS Specialist Certificates) Course Outline

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

This course can help prepare you for the following certification exam(s): SAS Certified Specialist: Base Programming Using SAS 9.4.

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 this class is for?
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, SAS programmers, DBA’s, business analysts., and data scientists.

Prerequisites
SAS Fundamentals course or equivalent.

Number of Days
3 days

COURSE OUTLINE

Introduction
• 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.

View outline in Word

XSAS02

Attend hands-on, instructor-led SAS Programming Intermediate (Test-Prep for the SAS Associate and SAS Specialist Certificates) training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.