SAS Programming 1: Essentials

Classroom duration: 3.0 days Live Web duration: 6 half-day sessions Please note the System Requirements below. Course fee: $1,425 EPTO units: 2.7 CEUs: 1.8		e-Course duration: 21 hours Price: $715 ETPO units: 1.5

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 Querying and Reporting Using SAS Enterprise Guide course.

This course replaces the SAS Programming I: Essentials course.

This course can help prepare you for the following certification exam(s): SAS Base Programming Exam for SAS 9.

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

Expand/Collapse All Expand All Collapse All Print version

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. 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.

Course Contents

Introduction

course logistics
an 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

introduction to validating and cleaning data
examining data errors when reading raw data files
validating data with the PRINT and FREQ procedures
validating data with the MEANS and UNIVARIATE procedures
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
contenating data sets
merging data sets one-to-one
merging data sets one-to-many
merging data sets with non-matches

Enhancing Reports

using global statements
adding labels and formats
creating user-defined formats
subsetting and grouping observations
directing output to external files

Producing Summary Reports

using the FREQ procedure
using the MEANS procedure
using the TABULATE procedure (Self-Study)

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

creating bar and pie charts
creating plots
enhancing output

Software

This course addresses Base SAS. This course also addresses SAS/ACCESS to PC Files and SAS/GRAPH software. This course is appropriate for students who are using SAS 9 software.

Course Materials

Classroom: Students attend classroom courses in one of our public training centers. You receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Live Web: Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials. Students need to download and print the course materials prior to class.

System Requirements

For Live Web, you must

review and follow the general system requirements.
complete the course exercises through our virtual lab. The virtual lab allows you to access the software used in class over the Internet, so that you do not need this software on your local machine.
run this test to connect to a virtual lab session. If firewall problems prevent you from connecting to the virtual lab, then you will need the following software installed and configured in your environment to participate in the course exercises:
- Base SAS 9.2 or 9.1.3 on a Windows operating system or SAS Learning Edition.
  Important: Students using SAS Learning Edition will need to create a shortcut to the SAS windowing environment (SAS Explorer, Enhanced Editor, Log, and Output windows) for use during the class. Follow these instructions for creating a shortcut to SAS prior to class.

Share Your Thoughts

Not sure if this course suits your needs or which delivery method is right for you? Give us a call at 800-333-7660 or send us e-mail. If you have suggestions for this course or would like for it to be offered at another training facility, let us know by adding to our Interest List.

This course is also offered as self-paced e-learning, which can be purchased and accessed from the SAS e-Learning catalog.

This page was created using SAS software.

Learning Center

Stay in Touch

Not sure what course to take?

Submit Your Course Requests

On-site Pricing