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

Contents

• Introduction Introduction

  • Use functions to manipulate your data

    15s
• 1. Understanding SAS Functions and CALL Routines 1. Understanding SAS Functions and CALL Routines

  • Review of functions

    44s
  • Specifying columns lists

    1m 1s
  • Using a CALL routine to modify data

    1m 25s
• 2. Using Numeric and Date Functions 2. Using Numeric and Date Functions

  • Useful numeric functions

    1m 5s
  • Demo: Using numeric functions

    2m 57s
  • SAS Date, Datetime, and Time Values

    53s
  • Extracting data from a Datetime value

    30s
  • Calculating date intervals

    2m 1s
  • Shifting date values

    50s
  • Demo: Shifting date values based on an interval

    3m 14s
• 3. Using Character Functions 3. Using Character Functions

  • Useful character functions

    53s
  • Extracting words from a string

    58s
  • Demo: Using character functions to extract words from a string

    3m 16s
  • Searching for character strings

    51s
  • Replacing character strings

    27s
• 4. Using Special Functions to Convert Column Type 4. Using Special Functions to Convert Column Type

  • Handling column type

    35s
  • Converting column type

    1m 18s
  • Converting character values to numeric values

    1m 33s
  • Using a generic informat to read dates

    1m 33s
  • Converting the type of an existing column

    1m 46s
  • Converting numeric values to character values

    1m 2s
  • Demo: Using the INPUT function to convert column types

    7m 9s
  • Demo: Using the PUT function to convert column types

    3m 38s