SAS Programming 2: Data Manipulation Techniques

Duration: 3.0 days
Course fee: $1,980
EPTO units: 3
CEUs: 1.8

This outline is provisional and subject to change.

This course is for those who need to learn SAS DATA step programming techniques for processing, controlling, and manipulating SAS data sets. The course builds on the concepts that are presented in the SAS Programming I: Essentials course and is not recommended for beginning SAS software users.

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

Learn how to

control SAS data set input and output
combine SAS data sets
summarize, read, and write different types of data
perform DO loop and SAS array processing
transform character, numeric, and date variables.

Who should attend

Business analysts and SAS programmers

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

Before attending this course, you should have at least six months of experience writing SAS programs or have completed the SAS Programming I: Essentials course and used SAS for at least one month. Specifically, you should be able to

create and access files in your operating environment
explain the structure of a SAS program
explore the structure and contents of a SAS data set
distinguish between syntax and data errors
debug a SAS program
create a SAS data set from a fixed-format external file
subset the rows and columns of a SAS data set
create derived variables
write conditional logic statements
read and write SAS date values
access SAS data libraries
sort a SAS data set
read one or more SAS data sets using a SET statement
perform a simple merge using a MERGE statement
create detail and summary reports from a SAS data set
place titles and footnotes on reports.

Course Contents

Introduction

review of SAS basics
review of DATA step processing
review of displaying SAS data sets
working with existing SAS data sets

Controlling Input and Output

outputting multiple observations
writing to multiple SAS data sets
selecting variables and observations
writing to external files

Summarizing Data

creating an accumulating total variable
accumulating totals for a group of data

Reading and Writing Different Types of Data

reading delimited raw data files
controlling when a record loads
reading hierarchical raw data files

Data Transformations

manipulating character variables
manipulating numeric variables
manipulating numeric variables based on dates
converting variable type

Processing Data Iteratively

performing DO loop processing
performing SAS array processing

Combining SAS Data Sets

match-merging two or more SAS data sets
performing simple joins using the SQL procedure (self-study)

Learning More

identifying additional resources

Software

This course addresses Base SAS. This course is appropriate for students who are using SAS Version 8 or SAS 9 software.

Course Materials

Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Course fee and EPTO units will differ for on-site training.

This page was created using SAS software.

-	Public
-	On-site training
-	One-to-one Mentoring
-	Courses by Industry Experts
-	Targeted Learning
-	ABM Training
-	TPS Service
-	Find a Course
-	Register now
-	Course list
-	Curriculum paths
-	Locations
-	Special Offers