SAS® 9.4 Cert Prep: Part 10 Manipulating Data with Functions

Introduction

• Use functions to manipulate your data

1. Understanding SAS Functions and CALL Routines

• Review of functions
• Specifying columns lists
• Using a CALL routine to modify data

2. Using Numeric and Date Functions

• Useful numeric functions
• Demo: Using numeric functions
• SAS Date, Datetime, and Time Values
• Extracting data from a Datetime value
• Calculating date intervals
• Shifting date values
• Demo: Shifting date values based on an interval

3. Using Character Functions

• Useful character functions
• Extracting words from a string
• Demo: Using character functions to extract words from a string
• Searching for character strings
• Replacing character strings

4. Using Special Functions to Convert Column Type

• Handling column type
• Converting column type
• Converting character values to numeric values
• Using a generic informat to read dates
• Converting the type of an existing column
• Converting numeric values to character values
• Demo: Using the INPUT function to convert column types
• Demo: Using the PUT function to convert column types