SAS Programming

Course Description

The SAS language is a computer programming language used for statistical analysis, created by Anthony James Barr at North Carolina State University.[1][2] It can read in data from common spreadsheets and databases and output the results of statistical analyses in tables, graphs, and as RTF, HTML and PDF documents. The SAS language runs under compilers that can be used on Microsoft Windows, Linux, and various other UNIX and mainframe computers. The SAS System and World Programming System (WPS) are SAS language compilers.

You will learn

  • Read and create data files.
  • Manipulate and transform data
  • Combine SAS data sets.
  • Create basic detail and summary reports using SAS procedures.
  • Identify and correct data, syntax and programming logic errors

Course Outline

Unit 1: Access and Create Data Structures
  • Create temporary and permanent SAS data sets
  • Investigate SAS data libraries using base SAS utility procedures
  • Combine SAS data sets
  • Access an Excel workbook
  • Create and manipulate SAS date values
  • Export data to create standard and comma-delimited raw data files
  • Control which observations and variables in a SAS data set are processed and output
Unit 2: Manage Data
  • Sort observations in a SAS data set.
  • Conditionally execute SAS statements
  • Use assignment statements in the DATA step.
  • Modify variable attributes using options and statements in the DATA step.
  • Accumulate sub-totals and totals using DATA step statements.
  • Use SAS functions to manipulate character data, numeric data, and SAS date values.
  • Use SAS functions to convert character data to numeric and vice versa
  • Process data using DO LOOPS.
  • Validate and clean data.
Unit 3: Generate Reports
  • Generate list reports using the PRINT procedure.
  • Generate summary reports and frequency tables using base SAS procedures.
  • Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting.
  • Generate reports using ODS statements.
Unit 4: Error Handling
  • Identify and resolve programming logic errors.
  • Recognize and correct syntax errors.
  • Examine and resolve data errors.


No schedule yet, contact us for register, we will contact you when we have classes

Prepare for exam

Exam A00-211