Share Description
In this course, you will :
- Explore SAS functions for transforming data into usable formats.
- explains how to use functions to modify numeric, date, and character data, as well as change data types.
Syllabus :
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
