SAS® Programming 2: Data Manipulation Techniques Training

Before attending this course, you should be able to do the following:

• write DATA step code to subset rows and columns, compute new columns, and process data conditionally
• sort tables using the SORT procedure
• apply SAS formats

This course addresses Base SAS software.

• understand and control DATA step processing
• create an accumulating column and process data in groups
• manipulate data with functions
• convert column type
• create custom formats
• concatenate and merge tables
• process repetitive code
• restructure tables.

Controlling DATA Step Processing

• setting up for this course
• understanding DATA step processing
• directing DATA step output

Summarizing Data

• creating an accumulating column
• processing data in groups

Manipulating Data with Functions

• understanding SAS functions and CALL routines
• using numeric and date functions
• using character functions
• using special functions to convert column type

Creating Custom Formats

• creating and using custom formats
• creating custom formats from tables

Combining Tables

• concatenating tables
• merging tables
• identifying matching and nonmatching rows

Processing Repetitive Code

• using iterative DO loops
• using conditional DO loops

Restructuring Tables

• restructuring data with the DATA step
• restructuring data with the TRANSPOSE procedure