Return to Archive

SAS Tip of the Month
July 2006

There are three functions that can effect the case of the of text within a character string - LOWCASE, UPCASE and PROPCASE. The following example demonstrates their use:

   22 data _null_;
   23 TextStr="THE COW JUMPED OVER THE MOON";
   24 TextStr_Lower=lowcase(TextStr);
   25 TextStr_Upper=upcase(TextStr);
   26 TextStr_Propper=propcase(TextStr);
   27 put TextStr= /
   28 TextStr_Lower= /
   29 TextStr_Upper= /
   30 TextStr_Propper=;
   31 run;
   TextStr=THE COW JUMPED OVER THE MOON
   TextStr_Lower=the cow jumped over the moon
   TextStr_Upper=THE COW JUMPED OVER THE MOON
   TextStr_Propper=The Cow Jumped Over The Moon

Note how the three functions effected the original text string.

________________________________
Updated July 1, 2006