Data Manipulation & Debugging

SAS 9    |    Beginner
  • 10 videos | 56m 25s
  • Includes Assessment
  • Earns a Badge
Rating 4.2 of 29 users Rating 4.2 of 29 users (29)
An impressive feature of SAS is the assortment of functions that deal with character and numeric data. Explore various functions for data transformation, and some methods for debugging your programs.

WHAT YOU WILL LEARN

  • Use various sas functions to perform transforms or calculations on variables
    Use sas functions to extract and transform character values, including substr, left, right, char, propcase, and length
    Use sas functions to separate and concatenate character values, including trim, strip, scan, cat, catt, cats, catx, and ||
    Use sas functions to find and modify character values, including find, substr, compress, and tranwrd
    Use descriptive sas statistical functions, such as sum, min, max, and mean
  • Truncate numerical sas values by using the round, int, floor, and ceil functions
    Convert between sas data types using input and put functions
    Debug sas programs using the putlog statement
    Debug logic errors in sas programs
    Create a program that manipulates input data

IN THIS COURSE

  • 4m 26s
    Learn how to use various SAS functions to perform transforms or calculations on variables. FREE ACCESS
  • 6m 2s
    During this video, you will learn how to use SAS functions to extract and transform character values, including SUBSTR, LEFT, RIGHT, CHAR, PROPCASE, and LENGTH. FREE ACCESS
  • Locked
    3.  Separating and Concatenating Character Values
    8m 6s
    Learn how to use SAS functions to separate and concatenate character values, including TRIM, STRIP, SCAN, CAT, CATT, CATS, CATX, and ||. FREE ACCESS
  • Locked
    4.  Finding and Modifying Character Values
    7m 38s
    Learn how to use SAS functions to find and modify character values, including FIND, SUBSTR, COMPRESS, and TRANWRD. FREE ACCESS
  • Locked
    5.  Using Descriptive Statistics Functions
    3m 19s
    Learn how to use the descriptive SAS statistical functions SUM, MIN, MAX, and MEAN. FREE ACCESS
  • Locked
    6.  Truncating Numeric Values
    4m 28s
    During this video, you will learn how to truncate numerical SAS values by using the ROUND, INT, FLOOR, and CEILING functions. FREE ACCESS
  • Locked
    7.  Converting Values Between Data Types
    7m 55s
    In this video, you will learn how to convert between SAS data types using the INPUT and PUT functions. FREE ACCESS
  • Locked
    8.  Debugging with PUTLOG
    4m 39s
    To debug a SAS program, use the PUTLOG statement. FREE ACCESS
  • Locked
    9.  Debugging Logic Errors
    4m 21s
    In this video, you will learn how to debug logic errors in SAS programs. FREE ACCESS
  • Locked
    10.  Exercise: Manipulating Data
    5m 31s
    In this video, you will learn how to create a program that manipulates input data. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Journey Microsoft Excel
Rating 2.7 of 3 users Rating 2.7 of 3 users (3)
Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Channel R for Data Science
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Tableau for Data Visualization: Introduction
Rating 4.5 of 557 users Rating 4.5 of 557 users (557)
Course Device Configuration & Data Storage
Rating 4.5 of 29 users Rating 4.5 of 29 users (29)
Course Working with Arrays & Restructuring and Merging Data Sets
Rating 4.5 of 27 users Rating 4.5 of 27 users (27)