support & services / Education

SAS Programming 1: Essentials – UK_PRG1

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.

Download course description as PDF  Register now 

Duration

3 days - Classroom

SAS Programming Certification Packages

SAS Certification

To take advantage of one of the SAS Programming Certification Packages, simply quote 'BEST VALUE' in the Campaign Code field when booking your first item. We will then contact you to prompt the purchases of the other package items.

Learn how to:

  • navigate the SAS windowing environment
  • read various types of data into SAS data sets
  • validate and clean SAS data sets
  • create SAS variables and subset data
  • combine SAS data sets
  • create and enhance listing and summary reports

Who should attend?

Anyone getting started writing SAS programs

Prerequisites

Before attending this course, you should have experience using computer software. Specifically, you should be able to

  • understand file structures and system commands on your operating systems
  • access data files on your operating systems.

No prior SAS experience is needed.

Course Contents:

Introduction

  • course logistics
  • overview of Foundation SAS

Getting Started with SAS

  • introduction to SAS programs
  • submitting a SAS program

Working with SAS Syntax

  • mastering fundamental concepts
  • diagnosing and correcting syntax errors

Getting Familiar with SAS Data Sets

  • examining descriptor and data portions
  • accessing SAS data libraries
  • accessing relational databases (self-study)

Reading SAS Data Sets

  • introduction to reading data
  • using SAS data as input
  • subsetting observations and variables
  • adding permanent attributes

Reading Excel Worksheets

  • using Excel data as input
  • doing more with Excel worksheets (self-study)

Reading Delimited Raw Data Files

  • using standard delimited data as input
  • using nonstandard delimited data as input

Validating and Cleaning Data

  • examining data errors when reading raw data files
  • validating data with the PRINT
  • cleaning invalid data

Manipulating Data

  • creating variables
  • creating variables conditionally
  • subsetting observations

Combining SAS Data Sets

  • introduction to combining data sets
  • appending a data set (self-study)
  • concatenating data sets
  • merging data sets one-to-one
  • merging data sets one-to-many
  • merging data sets with nonmatches

Producing Summary Reports

  • using the FREQ procedure
  • using the MEANS procedure
  • using the TABULATE procedure (self-study)

Enhancing Reports

  • using global statements
  • adding labels and formats (self-study review)
  • creating user-defined formats
  • subsetting and grouping observations (self-study review)
  • directing output to external files

Introduction to Graphics Using SAS/GRAPH (Self-Study)

  • creating bar and pie charts
  • creating plots
  • enhancing output

Learning More

  • SAS resources
  • beyond this course

Software Addressed

This course addresses the following software product(s): Base SAS. This course also addresses SAS/ACCESS to PC Files and SAS/GRAPH software. This course is appropriate for learners who are using SAS 9 software.