What's New Table of Contents 

What's New in SAS Data Quality Server 9.0, 9.1, and 9.1.2


New capabilities, functions, and options in SAS Data Quality Server (formerly called SAS Data Quality - Cleanse) improve your ability to:

Note:   z/OS is the successor to the OS/390 operating system. SAS Data Quality Server 9.1 is supported on both OS/390 and z/OS operating systems. Throughout this document, any reference to z/OS also applies to OS/390.

General Enhancements


The following locales are provided:


The following new functions interpret input character values that have been parsed (and therefore contain delimiters):

The next set of new functions helps you prepare parsed character values:

The new function DQLOCALEINFOGET returns a list of the locales that are currently loaded into memory.

The new function DQPATTERN returns a pattern analysis of the words or characters in an input character value.

The existing function DQSCHEMEAPPLY and the existing CALL routine CALL DQSCHEMEAPPLY now accept the following new arguments: <scheme-lookup-method>, <match-definition>, <sensitivity>, and <locale>. These arguments implement the new scheme-apply capabilities that are also available in the DQSCHEME procedure for the APPLY statement.

System Options

The following system options are new or have changed:


The following AUTOCALL macros are new or have changed:

DQSCHEME Procedure

In the PROC DQSCHEME statement, the BFD and NOBFD options enable you to generate schemes in SAS format and in BFD format. BFD format schemes can be displayed and edited using dfPower Customize from DataFlux (a SAS company).

The new CONVERT statement enables you to convert existing schemes between SAS and BFD formats.

For the CREATE statement in the DQSCHEME procedure, the following options are new or have been changed:

For the APPLY statement in the DQSCHEME procedure, MODE= specifies whether to apply the scheme to the entire input value or to each element of the input value. The default value is determined by the value of MODE= that was stored in the scheme when the scheme was created.

DQMATCH Procedure

For the PROC DQMATCH statement, the options DELIMITER and NODELIMITER enable you to generate concatenated match codes with or without a delimiter.

For the CRITERIA statement in the DQMATCH procedure, the following options are new or have been changed: