NOTE: The PROPCASE Function

March 28, 2011
By

This post was kindly contributed by NOTE: The blog of RTSL.eu - Development with SAS® - go there to comment and to read the full post.

Here’s just a brief post about a function I just stumbled across. The PROPCASE function coverts a string to “proper case” wherein the first letter of each word is upper case and all others are lower case. Clearly this is a very useful thing for column headings and labels.

Slightly off topic, but worth a mention, you can do this in Microsoft Office products by positioning the insertion pointer within a word or by selecting text (either one word, or a phrase, or a sentance, or more) and then pressing Shift-F3. Pressing Shift-F3 multiple times cycles between several different forms of “case”. I use it primarily in Word, Outlook and Powerpoint. It works slightly differently depending upon whether you have a full stop at the end of a sentance! With a full stop, it cycles between upper case, lower case, and simple sentance case (first letter of first word is upper case) . With no full stop it cycles between upper case, lower case, and proper case.

In recent versions of Office, you may find a ChangeCase button in the Font group in the Home tab. Clicking this offers a menu of sentance case, lower case, upper case, capitalise each word, and toggle case.

Note, Shift-F3 is assigned to the ChangeCase command by default, but your Office administrator may have changed the assignment.

OpenOffice contains similar functionality.

This post was kindly contributed by NOTE: The blog of RTSL.eu - Development with SAS® - go there to comment and to read the full post.

Tags: , , ,

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.