DQCASE Function

Returns a character value with standardized capitalization.

Valid in:	DATA step, PROC SQL, and SCL
Requirement:	The specified locale must be loaded into memory as part of the locale list.

Syntax

DQCASE (char, 'case-definition' <, 'locale'> )

char: specifies a character constant, variable, or expression that contains the value that is transformed, according to the specified case definition.

case-definition: the character constant, variable, or expression to search. The definition must be in the locale that is used. If the value of char is represented by a case definition, the use of that definition is recommended over the generic case definition.

If the value of char is a street address and you are using the ENUSA locale, the recommended case definition is PROPER–ADDRESS. This is used instead of the generic case definition PROPER.

locale: specifies a character constant, variable, or expression that contains the locale name.

Default:The default locale is the first locale in the locale list. If no value is specified, the default locale is used.

The DQCASE function operates on any character content, such as names, organizations, and addresses.

The following example standardizes the capitalization and spacing with the PROPER case definition in the ENUSA locale.

orgname=dqCase("BILL'S PLUMBING & HEATING", 'Proper', 'ENUSA');

After this function call, the value of ORGNAME is Bill's Plumbing & Heating.