What's New in SAS Data Quality Server 9.2

The SAS Data Quality Server software now provides procedures and functions that enable you to run jobs and services on DataFlux Integration Servers from DataFlux (a SAS company). Other procedures and functions enable you to administer DataFlux Integration Servers. In SAS 9.2 Phase 2, all of the language elements that access DataFlux Integration Servers are enabled in the z/OS operating environment.

The DQOPTIONS= system option now enables you to configure your SAS session to enhance the performance of data quality programs.

The procedure DQSRVSVC now offers the options MISSINGVARSOK and TRIM.

The SAS Data Quality Server 9.2: Reference now contains information about conditional clustering enhancements.

The following procedures and functions support DataFlux Integration Servers:

PROC DQSRVSVC

runs real-time services on DataFlux Integration Servers. The services are created with the dfPower Architect software from DataFlux. Starting in SAS 9.2 Phase 2, the TRIM statement removes blank spaces from the ends of input character strings. Also, the statement MISSINGVARSOK allows DataFlux services to run when variables are missing from the input data set.

PROC DQSRVADM

creates job status data sets after querying DataFlux Integration Servers.

DQSRVARCHJOB

runs jobs on DataFlux Integration Servers. The jobs are created with the dfPower Architect software from DataFlux.

DQSRVCOPYLOG, DQSRVDELETELOG

manage log entries on DataFlux Integration Servers.

DQSRVJOBSTATUS

reads log entries from DataFlux Integration Servers.

DQSRVKILLJOB

terminates jobs that are running on DataFlux Integration Servers.

DQSRVPROFJOBFILE

runs analysis jobs on individual files on DataFlux Integration Servers. The jobs are created with the dfPower Profile software from DataFlux.

DQSRVPROFJOBREP

runs analysis jobs on repositories.

DQSRVUSER

authenticates users on DataFlux Integration Servers.

Starting in SAS 9.2 Phase 2, all of the procedures and functions that access DataFlux Integration Servers can now be used in the z/OS operating environment.

Starting in SAS 9.2 Phase 2, the system option DQOPTIONS= is now available for use in the SAS start-up command and in the SAS configuration file. The value of the option is a series of option-value pairs. The options that are currently available are TRANSCODE= option and the DQSRVPROTOCOL= option . The TRANSCODE= option tells SAS not to terminate execution if errors are encountered during the translation of languages and character sets. The DQSRVPROTOCOL= option is used to specify the WIRELINE protocol. This increases data transfer performance to and from DataFlux Integration Servers.

Starting in SAS 9.2 Phase 2, the DQPARSE function is complemented by the DQPARSE CALL routine. The new CALL routine returns a flag that indicates the status of the parse operation (success or failure).

Starting in SAS 9.2 Phase 2, the DQSRVSVC procedure now offers two new options: TRIM and MISSINGVARSOK. TRIM removes blank spaces from the ends of input data sets that are processed by real-time services. The real-time services are executed on DataFlux Integration Servers. MISSINGVARSOK enables the continuation of processing when an input data set is missing one or more variables.

The clustering capability of the DQMATCH procedure was enhanced so that clustering criteria could be grouped into a series of conditions. Conditional clustering, as implemented in the CONDITION= and EXACT options of the CRITERIA statement, are now documented in the SAS Data Quality Server: Reference.

Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.