Previous Page | Next Page

Functions and CALL Routines

DQCASE Function



Returns a character value with standardized capitalization.
Requirement: The specified locale must be loaded into memory as part of the locale list.
Valid in: DATA step, PROC SQL, and SCL

Syntax
Arguments
Details
Example

Syntax

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

Arguments

char

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

case-definition

is 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.

Details

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


Example

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.

Previous Page | Next Page | Top of Page