SAS Programming 1: Essentials

Anyone starting to write SAS programs


  • Experience using computer software
  • Knowledge of file structures and system commands on your operating systems
  • Ability to access data files on your operating systems

Note: No prior SAS experience is needed. If you do not feel comfortable withÿ the prerequisites or are new to programming and think that the pace of this course might be too demanding, you can take the SAS Programming Introduction: Basic Concepts course before attending this course. SAS Programming Introduction: Basic Concepts is designed to introduce you to computer programming and presents a portion of the SAS Programming 1: Essentials material at a slower pace.

Expected Duration
3 day


This course is for users who want to learn how to write SAS programs. It is the entry point to learning SAS programming and is a prerequisite to many other SAS courses. If you do not plan to write SAS programs and you prefer a point-and-click interface, you should attend the SAS Enterprise Guide 1: Querying and Reporting course.


SAS Certified Clinical Trials Programmer Using SAS 9


1. Introduction

  • Overview of SAS Foundation
  • Course logistics
  • Course data files

2. SAS Programs

  • Introduction to SAS programs
  • Submitting a SAS program
  • SAS program syntax

3. Accessing Data

  • Examining SAS data sets
  • Accessing SAS libraries

4. Producing Detail Reports

  • Subsetting report data
  • Sorting and grouping report data
  • Enhancing reports

5. Formatting Data Values

  • Using SAS formats
  • Creating user-defined formats

6. Reading SAS Data Sets

  • Reading a SAS data set
  • Customizing a SAS data set

7. Reading Spreadsheet and Database Data

  • Reading spreadsheet data
  • Reading database data

8. Reading Raw Data Files

  • Introduction to reading raw data files
  • Reading standard delimited data
  • Reading nonstandard delimited data
  • Handling missing data

9. Manipulating Data

  • Using SAS functions
  • Conditional processing

10. Combining Data Sets

  • Concatenating data sets
  • Merging data sets one-to-one
  • Merging data sets one-to-many
  • Merging data sets with nonmatches

11. Creating Summary Reports

  • Using the FREQ procedure
  • Using the MEANS and UNIVARIATE procedures
  • Using the Output Delivery System

12. Learning More

  • SAS resources
  • Next steps



Select Course Options