SAS® Programming: Data Manipulation Techniques

Role

Data Manager, SAS Programmer

Duration

3 days

Description

This course builds on the concepts presented in the SASŪ Essentials: An Introduction to Programming course. It focuses on how to manage SAS data set input and output, work with different data types and manipulate data.

Prerequisites

Before attending this course 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 data set from a fixed-width 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.
• Create detail and summary reports from a SAS data set.
• Place titles and footnotes on reports

SAS Modules Used

Base SAS

Course Topics

Controlling Input and Output:

• Outputting Multiple Observations
• Writing to Multiple SAS Data Sets
• Selecting Variables and Observations.

Summarising Data:

• Creating an Accumulating Total Variable
• Accumulating Totals for Groups of Data

Reading and Writing Different Types of Data

• Reading Delimited Raw Data Files
• Controlling When a Record Loads
• Reading Hierarchical Raw Data Files
• Writing to an External File.

Data Transformations, Introduction

• Manipulating Character Values
• Manipulating Numeric Values
• Manipulating Numeric Values Based on Dates
• Converting Data Types

Debugging Techniques

• Using the PUT Statement
• Using the DEBUG Option

Processing Data Iteratively:

• DO Loop Processing
• SAS Array Processing
• Using SAS Arrays.

Combining SAS Data Sets

• Match-Merging Two or More SAS Data Sets
• Simple Joins Using the SQL Procedure

Objectives

After attending this course, you will be able to: Read and write different types of data, Combine SAS data sets, Summarise data, Perform data manipulation and transformation using SAS functions, Use options and statements to identify logic problems, Process data iteratively, Use arrays, Understand DATA step processing.