| Transforming Data with SAS Functions | |
Modifying Character Values with
Functions |
|
| LOWCASE Function
The LOWCASE function converts all letters in a character expression to lowercase. |
General form, LOWCASE function:
where argument can be any SAS expression, such as a character value or constant. |
Here's an example of the LOWCASE function. In this example, the function
converts the values of a variable named Title to lowercase letters.
lowcase(title)
Another example of the LOWCASE function is shown below. The assignment statement
in this DATA step uses the LOWCASE function to convert the values of the
variable data hrd.newtemp;
set hrd.temp;
Contact=lowcase(contact);
run;
|
SAS Data Set Hrd.Temp
| Job | Contact | Department | Site |
| word processing | WORD PROCESSOR | DP | 26 |
| filing, administrative duties | ADMIN. ASST. | PURH | 57 |
| organizational dev. specialist | CONSULTANT | PERS | 34 |
After this DATA step is executed, the new data set is created. Notice
the converted values of the variable Contact. |
SAS Data Set Hrd.Newtemp
| Job | Contact | Department | Site |
| word processing | word processor | DP | 26 |
| filing, administrative duties | admin. asst. | PURH | 57 |
| organizational dev. specialist | consultant | PERS | 34 |
     |
|
|
|