SAS(R) Data Quality Server 9.2: Reference

PDF | Purchase

Product	Release
DataFlux Integration Server for SAS	8.0
DataFlux dfPower Platform	8.0
SAS BI Server
SAS Data Integration Studio	9.2
SAS Enterprise BI Server	9.2
SAS Enterprise Data Integration Server
DataQuality Plug-in for SAS Data Integration Studio

Functions and CALL Routines

DQMATCHPARSED Function

Returns a match code from a parsed character value.

Valid in:

DATA step, PROC SQL, or SCL

Syntax
Example
See Also

Syntax

DQMATCHPARSED(parsed-char, `match-definition' <, sensitivity>, <, `locale'>)

parsed-char

is a parsed character value for which a match code will be created. 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. The value must have been parsed with the parse definition that is associated with the specified match definition. To determine the name of the associated parse definition, use the DQMATCHINFOGET function. To determine the tokens that are enabled by that parse definition, use the DQPARSEINFOGET function.

match-definition

specifies the name of the match definition.

sensitivity

(optional) specifies an integer value that determines the amount of information in the returned match code. Valid values range from 50 to 95. The default value is 85. A higher sensitivity value inserts more information in the match code. In general, higher sensitivity values result in a greater number of clusters, with fewer members per cluster; input values must be more similar to receive the same match codes.

locale

(optional) specifies the name of the locale that contains the specified match 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. If no value is specified, the default locale is used. The default locale is the first locale in the locale list. For information on the locale list, see Load and Unload Locales.

Example

The following example returns a match code for the parsed name of an individual. The amount of information in the match code will be high.

data _null_;
   length nameIndividual matchCode $ 20 parsedName $ 200;
   nameIndividual='Susan B. Anthony';
   parsedName=dqParse(nameIndividual, 'name', 'enusa');
   matchCode=dqMatchParsed(parsedName, 'name', 90, 'enusa');
run;