Optional Arguments

ALLOBS

includes in the report of value comparison results the values and, for numeric variables, the differences for all matching observations, even if they are judged equal.

Default:If you omit ALLOBS, then PROC COMPARE prints values only for observations that are judged unequal.

Interaction:When used with the TRANSPOSE option, ALLOBS invokes the ALLVARS option and displays the values for all matching observations and variables.

ALLSTATS

prints a table of summary statistics for all pairs of matching variables.

See:Table of Summary Statistics for information about the statistics produced

ALLVARS

includes in the report of value comparison results the values and, for numeric variables, the differences for all pairs of matching variables, even if they are judged equal.

Default:If you omit ALLVARS, then PROC COMPARE prints values only for variables that are judged unequal.

Interaction:When used with the TRANSPOSE option, ALLVARS displays unequal values in context with the values for other matching variables. If you omit the TRANSPOSE option, then ALLVARS invokes the ALLOBS option and displays the values for all matching observations and variables.

BASE=SAS-data-set

specifies the data set to use as the base data set.

Alias:DATA=

Default:the most recently created SAS data set

Tip:You can use the WHERE= data set option with the BASE= option to limit the observations that are available for comparison.

BRIEFSUMMARY

produces a short comparison summary and suppresses the four default summary reports (data set summary report, variables summary report, observation summary report, and values comparison summary report).

Alias:BRIEF

Tip:By default, a listing of value differences accompanies the summary reports. To suppress this listing, use the NOVALUES option.

Example:Comparing Variables That Are in the Same Data Set

COMPARE=SAS-data-set

specifies the data set to use as the comparison data set.

Alias:COMP=, C=

Default:If you omit COMPARE=, then the comparison data set is the same as the base data set, and PROC COMPARE compares variables within the data set.

Restriction:If you omit COMPARE=, then you must use the WITH statement.

Tip:You can use the WHERE= data set option with COMPARE= to limit the observations that are available for comparison.

CRITERION=γ

specifies the criterion for judging the equality of numeric values. Normally, the value of γ (gamma) is positive. In that case, the number itself becomes the equality criterion. If you use a negative value for γ, then PROC COMPARE uses an equality criterion proportional to the precision of the computer on which SAS is running.

Default:0.00001

See:The Equality Criterion

ERROR

displays an error message in the SAS log when differences are found.

Interaction:This option overrides the WARNING option.

FUZZ=number

alters the values comparison results for numbers less than number. PROC COMPARE prints

• 0 for any variable value that is less than number
• a blank for difference or percent difference if it is less than number
• 0 for any summary statistic that is less than number.

Default:0

Range:0 - 1

Tip:A report that contains many trivial differences is easier to read in this form.

LISTALL

lists all variables and observations that are found in only one data set.

Alias:LIST

Interaction:using LISTALL is equivalent to using the following four options: LISTBASEOBS, LISTCOMPOBS, LISTBASEVAR, and LISTCOMPVAR.

LISTBASE

lists all observations and variables that are found in the base data set but not in the comparison data set.

Interaction:Using LISTBASE is equivalent to using the LISTBASEOBS and LISTBASEVAR options.

LISTBASEOBS

lists all observations that are found in the base data set but not in the comparison data set.

LISTBASEVAR

lists all variables that are found in the base data set but not in the comparison data set.

LISTCOMP

lists all observations and variables that are found in the comparison data set but not in the base data set.

Interaction:Using LISTCOMP is equivalent to using the LISTCOMPOBS and LISTCOMPVAR options.

LISTCOMPOBS

lists all observations that are found in the comparison data set but not in the base data set.

LISTCOMPVAR

lists all variables that are found in the comparison data set but not in the base data set.

LISTEQUALVAR

prints a list of variables whose values are judged equal at all observations in addition to the default list of variables whose values are judged unequal.

LISTOBS

lists all observations that are found in only one data set.

Interaction:Using LISTOBS is equivalent to using the LISTBASEOBS and LISTCOMPOBS options.

LISTVAR

lists all variables that are found in only one data set.

Interaction:Using LISTVAR is equivalent to using both the LISTBASEVAR and LISTCOMPVAR options.

MAXPRINT=total | (per-variable, total)

specifies the maximum number of differences to print, where

total

is the maximum total number of differences to print. The default value is 500 unless you use the ALLOBS option (or both the ALLVAR and TRANSPOSE options). In that case, the default is 32000.

per-variable

is the maximum number of differences to print for each variable within a BY group. The default value is 50 unless you use the ALLOBS option (or both the ALLVAR and TRANSPOSE options). In that case, the default is 1000.

The MAXPRINT= option prevents the output from becoming extremely large when data sets differ greatly.

METHOD=ABSOLUTE | EXACT | PERCENT | RELATIVE<(δ)>

specifies the method for judging the equality of numeric values. The constant δ (delta) is a number between 0 and 1 that specifies a value to add to the denominator when calculating the equality measure. By default, δ is 0.

Unless you use the CRITERION= option, the default method is EXACT. If you use the CRITERION= option, then the default method is RELATIVE(φ), where φ (phi) is a small number that depends on the numerical precision of the computer on which SAS is running and on the value of CRITERION=.

See:The Equality Criterion

NODATE

suppresses the display in the data set summary report of the creation dates and the last modified dates of the base and comparison data sets.

NOMISSBASE

(By default, a missing value is equal only to a missing value of the same kind, that is .=., .^=.A, .A=.A, .A^=.B, and so on.)

You can use this option to determine the changes that would be made to the observations in the comparison data set if it were used as the master data set and the base data set were used as the transaction data set in a DATA step UPDATE statement. For information about the UPDATE statement, see the chapter on SAS language statements in SAS System Options: Reference.

NOMISSCOMP

judges a missing value in the comparison data set equal to any value. (By default, a missing value is equal only to a missing value of the same kind, that is .=., .^=.A, .A=.A, .A^=.B, and so on.)

You can use this option to determine the changes that would be made to the observations in the base data set if it were used as the master data set and the comparison data set were used as the transaction data set in a DATA step UPDATE statement. For information about the UPDATE statement, see the chapter on SAS language statements in SAS System Options: Reference.

NOMISSING

judges missing values in both the base and comparison data sets equal to any value. By default, a missing value is equal only to a missing value of the same kind, that is .=., .^=.A, .A=.A, .A^=.B, and so on.

Alias:NOMISS

Interaction:Using NOMISSING is equivalent to using both NOMISSBASE and NOMISSCOMP.

NOPRINT

suppresses all printed output.

Tip:You may want to use this option when you are creating one or more output data sets.

Example:Comparing Values of Observations Using an Output Data Set (OUT=)

NOSUMMARY

suppresses the data set, variable, observation, and values comparison summary reports.

Tip:NOSUMMARY produces no output if there are no differences in the matching values.

Example:Comparing Variables in Different Data Sets

NOTE

displays notes in the SAS log that describe the results of the comparison, if differences were found.

NOVALUES

suppresses the report of the value comparison results.

Example:Overview: COMPARE Procedure

OUT=SAS-data-set

names the output data set. If SAS-data-set does not exist, then PROC COMPARE creates it. SAS-data-set contains the differences between matching variables.

See:Output Data Set (OUT=)

Example:Comparing Values of Observations Using an Output Data Set (OUT=)

OUTALL

writes an observation to the output data set for each observation in the base data set and for each observation in the comparison data set. The option also writes observations to the output data set that contains the differences and percent differences between the values in matching observations.

Tip:Using OUTALL is equivalent to using the following four options: OUTBASE, OUTCOMP, OUTDIF, and OUTPERCENT.

See:Output Data Set (OUT=)

OUTBASE

writes an observation to the output data set for each observation in the base data set, creating observations in which _TYPE_=BASE.

See:Output Data Set (OUT=)

Example:Comparing Values of Observations Using an Output Data Set (OUT=)

OUTCOMP

writes an observation to the output data set for each observation in the comparison data set, creating observations in which _TYPE_=COMP.

See:Output Data Set (OUT=)

Example:Comparing Values of Observations Using an Output Data Set (OUT=)

OUTDIF

writes an observation to the output data set for each pair of matching observations. The values in the observation include values for the differences between the values in the pair of observations. The value of _TYPE_ in each observation is DIF.

Default:The OUTDIF option is the default unless you specify the OUTBASE, OUTCOMP, or OUTPERCENT option. If you use any of these options, then you must specify the OUTDIF option to create _TYPE_=DIF observations in the output data set.

See:Output Data Set (OUT=)

Example:Comparing Values of Observations Using an Output Data Set (OUT=)

OUTNOEQUAL

suppresses the writing of an observation to the output data set when all values in the observation are judged equal. In addition, in observations containing values for some variables judged equal and others judged unequal, the OUTNOEQUAL option uses the special missing value ".E" to represent differences and percent differences for variables judged equal.

See:Output Data Set (OUT=)

Example:Comparing Values of Observations Using an Output Data Set (OUT=)

OUTPERCENT

writes an observation to the output data set for each pair of matching observations. The values in the observation include values for the percent differences between the values in the pair of observations. The value of _TYPE_ in each observation is PERCENT.

See:Output Data Set (OUT=)

OUTSTATS=SAS-data-set

writes summary statistics for all pairs of matching variables to the specified SAS-data-set.

Tip:If you want to print a table of statistics in the procedure output, then use the STATS, ALLSTATS, or PRINTALL option.

See:Output Statistics Data Set (OUTSTATS=)

Table of Summary Statistics

Example:Creating an Output Data Set of Statistics (OUTSTATS=)

PRINTALL

invokes the following options: ALLVARS, ALLOBS, ALLSTATS, LISTALL, and WARNING.

Example:Producing a Complete Report of the Differences

STATS

prints a table of summary statistics for all pairs of matching numeric variables that are judged unequal.

See:Table of Summary Statistics for information about the statistics produced.

TRANSPOSE

prints the reports of value differences by observation instead of by variable.

Interaction:If you also use the NOVALUES option, then the TRANSPOSE option lists only the names of the variables whose values are judged unequal for each observation, not the values and differences.

See:Comparison Results for Observations (Using the TRANSPOSE Option).

WARNING

displays a warning message in the SAS log when differences are found.

Interaction:The ERROR option overrides the WARNING option.