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 [...]
  • CRBM6
  • Délka 2 dny
  • 0 ITK bodů
  • 0 termínů
  • Praha (na vyžádání)

    Brno (na vyžádání)

    Bratislava (877 €)

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.

»

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
Aktuální nabídka
Školicí místo
Jazyk kurzu

Uvedené ceny jsou bez DPH.