Overview
-
Prepare to take the SAS 9.4 certification exam. Learn techniques for manipulating data with functions in SAS.
Syllabus
-
Introduction
- Use functions to manipulate your data
- Review of functions
- Specifying columns lists
- Using a CALL routine to modify data
- 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
- 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
- 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
