sas-training-courses
7829  Reviews star_rate star_rate star_rate star_rate star_half

SAS(R) Certification Review: SAS(R) 9.4 Base Programming Performance-Based Exam

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

Read More
$150 USD GSA  $136.02
Course Code CRBM6
Available Formats Classroom

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.

Skills Gained

  • 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 Can Benefit

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

Course Details

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.