| Functions and CALL Routines |
| Valid in: | DATA step, PROC SQL, or SCL |
| Syntax | |
| Details | |
| Example | |
| See Also |
Syntax |
| DQPARSE(parse-string, 'parse-definition' <, ' locale'>) |
is the value that is parsed according to the specified parse definition. The value can be the name of a character variable, a character value in quotation marks, or an expression that evaluates to a variable name or a quoted value.
specifies the name of the parse definition.
(optional) specifies the name of the locale that contains the specified parse definition. The value can be a name in quotation marks, the name of a variable whose value is a locale name, or an expression that evaluates to a variable name or to a quoted locale name.
The specified locale must be loaded into memory as part of the locale list.
| Default: | the first locale in the locale list. |
| Restriction: | if no value is specified, the default locale is used. |
| See: | Load and Unload Locales. |
| Details |
The DQPARSE function returns a parsed character value. The return value contains delimiters that identify the elements in the value that correspond to the tokens that are enabled by the parse definition. The delimiters in the value allow functions such as DQPARSETOKENGET to access the elements in the value based on specified token names.
Note: Always
use the DQPARSETOKENGET function to extract tokens from parsed values. To
extract tokens from values that do not contain delimiters, use the DQTOKEN
function.
| Example |
The following example parses the name of an individual. Then the DQPARSETOKENGET function returns the values of two of the tokens.
parsedValue=dqParse('Mrs. Sallie Mae Pravlik', 'NAME', 'ENUSA'); prefix=dqParseTokenGet(parsedValue, 'Name Prefix', 'NAME', 'ENUSA'); given=dqParseTokenGet(parsedValue, 'Given Name', 'NAME', 'ENUSA');
After these function calls, the value of the PREFIX variable is Mrs. and the value of the GIVEN variable is Sallie.
| See Also |
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.