While processing data, you will frequently need to change data types. Even if the data is of good quality, where numbers have been stored as numerical and all date fields have been specified with the correct date format, transformations or derivations from them may be required to perform analysis.
Some of the commonly used transformations and derivations for a data analyst where the data type is altered are the following:
- Converting from numerical into character
- Converting from character into numerical
- Using a date or datetime format
- Extracting information from data
To convert a number into a character, use the PUT function. The syntax is as follows:
Character_variable = put(numeric_variable, informat.);
To convert ...
