SAS® 9.4 Cert Prep: Part 10 Manipulating Data with Functions
40mBeginner2020-01-07
Authors
SAS Institute
Business analytics software and services
Course details
Want to get ahead in a crowded job market? Get certified with SAS. This course is part of a series by the SAS Institute, designed to prepare you for the SAS 9.4 certification exam. Here you can explore techniques for transforming data into useable formats with SAS functions. Instructor Stacey Syphus explains how to use functions to modify numeric, date, and character data, and change one data type to another.
Skills covered
SASStatisticsCert PrepData Science
Concepts
0. Introduction
- 01 - Use functions to manipulate your data
1. Understanding SAS Functions and CALL Routines
- 02 - Review of functions
- 03 - Specifying columns lists
- 04 - Using a CALL routine to modify data
2. Using Numeric and Date Functions
- 05 - Useful numeric functions
- 06 - Demo - Using numeric functions
- 07 - SAS Date, Datetime, and Time Values
- 08 - Extracting data from a Datetime value
- 09 - Calculating date intervals
- 10 - Shifting date values
- 11 - Demo - Shifting date values based on an interval
3. Using Character Functions
- 12 - Useful character functions
- 13 - Extracting words from a string
- 14 - Demo - Using character functions to extract words from a string
- 15 - Searching for character strings
- 16 - Replacing character strings
4. Using Special Functions to Convert Column Type
- 17 - Handling column type
- 18 - Converting column type
- 19 - Converting character values to numeric values
- 20 - Using a generic informat to read dates
- 21 - Converting the type of an existing column
- 22 - Converting numeric values to character values
- 23 - Demo - Using the INPUT function to convert column types
- 24 - Demo - Using the PUT function to convert column types