From the course: SAS® 9.4 Cert Prep: Part 10 Manipulating Data with Functions
Unlock this course with a free trial
Join today to access over 22,700 courses taught by industry experts.
Useful character functions - SAS Tutorial
From the course: SAS® 9.4 Cert Prep: Part 10 Manipulating Data with Functions
Useful character functions
- [Instructor] When character strings need to be validated, cleaned or modified functions are a necessity. You should already be familiar with using several common character functions, such as UPCASE and PROPCASE to correct inconsistent character case, or SUBSTR to extract characters from a character string. Now you'll learn about functions that remove, replace, find or concatenate character strings. Let's look at precipitation data from Japan as an example. You can see that the values in the station column have been recorded inconsistently. Some have dashes and others have spaces. We want to standardize station codes with no spaces or symbols. There are several functions you can use to remove characters from a string. Let's work on this in the next activity.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.