SAS® Programming 1: Essentials Training

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.

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

Who should attend?

Anyone getting started writing SAS programs

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

Introduction

• overview of SAS Foundation
• course logistics
• course data files

SAS Programs

• introduction to SAS programs
• submitting a SAS program
• SAS program syntax

Accessing Data

• examining SAS data sets
• accessing SAS libraries

Producing Detail Reports

• subsetting report data
• sorting and grouping report data
• enhancing reports

Formatting Data Values

• using SAS formats
• creating user-defined formats

Reading SAS Data Sets

• reading a SAS data set
• customizing a SAS data set

Reading Spreadsheet and Database Data

• reading spreadsheet data
• reading database data

Reading Raw Data Files

• introduction to reading raw data files
• reading standard delimited data
• reading nonstandard delimited data
• handling missing data

Manipulating Data

• using SAS functions
• conditional processing

Combining Data Sets

• concatenating data sets
• merging data sets one-to-one
• merging data sets one-to-many
• merging data sets with nonmatches

Creating Summary Reports

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

Learning More

• SAS resources
• next steps