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

Go to class
Write Review

Free Online Course: SAS® 9.4 Cert Prep: Part 10 Manipulating Data with Functions provided by LinkedIn Learning is a comprehensive online course, which lasts for Less than 1 hour of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. SAS® 9.4 Cert Prep: Part 10 Manipulating Data with Functions is taught by SAS Institute.

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
    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