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'>)

Required Arguments

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.

Optional Argument

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.

Details

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

Example: DQCASE Function

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.