# Data Manipulation & Debugging

SAS 9    |    Beginner
• 10 videos | 56m 25s
• Includes Assessment
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

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

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