SAS Quality Knowledge Base for Contact Information 26

Case Definitions

The SAS Quality Knowledge Base (QKB) Case definitions specify data and logic that can be used to uppercase, lowercase, or propercase a text string.

A case definition can be helpful in situations where casing rules are not straightforward. For example, consider the following German word:

Straße

When uppercasing this word, it is desirable to transform the "ß" character to a double "S":

STRASSE

A case definition for uppercasing German data can be used to perform this type of special processing.

Another example of when a case definition can be useful is when you want to propercase your data, but you want to use a list of exceptions to normal propercasing rules. Consider the following two company names:

DATAFLUX CORPORATION
SAS INSTITUTE

Using normal propercasing rules, the strings would be transformed to:

Dataflux Corporation
Sas Institute

Using a propercase definition designed for organization names, however, the values could be transformed to:

DataFlux Corporation
SAS Institute

Special rules for well-known values are built into case definitions in the QKB, enabling intelligent transformations like the ones shown in this section.