Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

SAS(R) Certification Review: Base Programming for SAS(R) 9 for FedEx Institute

Course Details
Code: FECRB
Tuition (USD): $1,100.00 • Classroom

This course provides a review of the majority of topics in the SAS Base Programming Exam for SAS 9. It addresses the five exam content areas: Accessing Data, Creating Data Structures, Managing Data, Generating Reports, and Handling Errors.

Skills Gained

  • read, create, and combine SAS data sets
  • sort observations with the SORT procedure
  • read raw data and Microsoft Excel files
  • create variables using assignment, conditional, and sum statements
  • manipulate data using SAS functions
  • process data with DO loops and arrays
  • create reports using the PRINT procedure, the FREQ procedure, and the MEANS procedure
  • create formats with the FORMAT procedure
  • create external files with ODS.

Who Can Benefit

  • SAS users who are interested in a review course before taking the SAS Base Programming Exam for SAS 9, part of the SAS Global Certification Program

Prerequisites

  • Before attending this course, you should
  • be an experienced programmer with knowledge of the five exam content areas
  • have taken SAS(R) Programming I: Essentials and SAS(R) Programming II: Manipulating Data with the DATA Step or have equivalent experience.

Course Details

Introduction

  • specifics about the SAS Base Programming Exam
  • specifics about this review course
  • SAS fundamental concepts

Working with SAS Data Sets

  • reading and creating data sets
  • selecting observations
  • sorting observations with the SORT procedure
  • combining data sets

Working with Raw Data Files and Microsoft Excel Files

  • reading raw data files
  • controlling when a record loads
  • reading Microsoft Excel files

Creating Variables

  • creating variables with the assignment statement
  • creating variables conditionally
  • creating accumulator variables

Manipulating Data

  • using functions to manipulate data
  • converting character and numeric data
  • processing data with DO loops
  • processing data with arrays

Generating Reports

  • creating detail reports with the PRINT procedure
  • creating formats with the FORMAT procedure
  • creating frequency tables with the FREQ procedure
  • creating summary reports with the MEANS procedure
  • directing reports to external files with ODS

Additional Information

  • more specifics about the SAS Base Programming exam
  • additional preparation resources
  • test-taking strategies

Practice Exam

  • SAS fundamental concepts
  • working with SAS data sets
  • working with raw data and Microsoft Excel files
  • creating variables
  • manipulating data
  • generating reports
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward