SAS(R) Data Quality Server 9.2: Reference

Product	Release
SAS Enterprise BI Server	4.2
SAS Data Quality Server	9.2
SAS Enterprise Data Integration Server
SAS BI Server
SAS Data Integration Studio	4.2
DataFlux dfPower Studio
DataFlux Enterprise Integration Server

The DQSCHEME Procedure

DQSCHEME Procedure Syntax

Tips:	CREATE and APPLY statements can appear in any order in the DQSCHEME procedure. All CREATE statements are processed before all APPLY statements regardless of their order of appearance. All CONVERT statements are processed last, regardless of their order of appearance in the procedure.
See also:	Transform Data with Schemes.

PROC DQSCHEME
<DATA=input-data-set>
<BFD | NOBFD>
<OUT=output-data-set>;

<CREATE options;>
<APPLY options;>
<CONVERT options;>

The DQSCHEME procedure offers the following options:

BFD | NOBFD

specifying BFD indicates that all Blue Fusion Data that are created or applied in the current procedure step are in BFD format. Specifying NOBFD indicates that all schemes are in SAS format. The default value is BFD.

CAUTION:: Always specify NOBFD when creating schemes in the z/OS operating environment.
Schemes in BFD format can be applied but not created.

The DQSCHEME procedure can create and apply schemes in either format. Schemes in BFD format can be edited using the feature-rich graphical user interface of the dfPower Studio software from DataFlux (a SAS company).

Note:

In schemes using SAS format, data set labels are used to store meta options (see Meta Options). Therefore, you should not specify data set labels in scheme data sets that are stored in SAS format. If you do specify data set labels in scheme data sets, you overwrite the scheme metadata. [cautionend]

DATA=input-SAS-data-set

identifies the SAS data set from which one or more schemes are built, when you use the CREATE statement. When you use the APPLY statement to apply existing schemes, the DATA= option specifies the data set against which the schemes are applied.

The default data set is the most recently created data set in the current SAS session.

OUT=output-data-set

specifies the name of the output data set. If the specified data set does not exist, it is created by the DQSCHEME procedure.

If you use one or more APPLY statements, you must use the OUT= option to specify the name of the output data set. Results are written to the output data set after all schemes have been applied. If you specify OUT= without any APPLY statements, an empty output data set is created.

Default:

the default output data set is the input data set.

Top of Page