SAS Institute. The Power to Know

SAS(R) Data Quality Server 9.2: Reference

Previous Page | Next Page

Functions and CALL Routines

DQPARSE Function



Returns a parsed character value.
Valid in: DATA step, PROC SQL, or SCL

Syntax
Details
Example
See Also

Syntax

DQPARSE(parse-string, 'parse-definition' <, ' locale'>)

parse-string

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.

parse-definition

specifies the name of the parse definition.

locale

(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.  [cautionend]


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

Previous Page | Next Page | Top of Page