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,600 courses taught by industry experts.
Handling column type - SAS Tutorial
From the course: SAS® 9.4 Cert Prep: Part 10 Manipulating Data with Functions
Handling column type
- [Narrator] SAS offers some functions that have specialized purposes. Let's consider a very common issue, dealing with column type. You know that columns in SAS are either character or numeric, and there are certain actions that depend on data being specifically character or numeric. For example, arithmetic calculations require numeric values, and character functions, such as SUBSTRING or SCAN, require character values. What happens when you try to perform an action in the DATA step on a column that isn't the proper type?
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.
Contents
-
-
-
-
-
-
(Locked)
Handling column type35s
-
(Locked)
Converting column type1m 18s
-
(Locked)
Converting character values to numeric values1m 33s
-
(Locked)
Using a generic informat to read dates1m 33s
-
(Locked)
Converting the type of an existing column1m 46s
-
(Locked)
Converting numeric values to character values1m 2s
-
Demo: Using the INPUT function to convert column types7m 9s
-
(Locked)
Demo: Using the PUT function to convert column types3m 38s
-
(Locked)