 |
|
| 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.
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.