Compare Data Sets

This process uses SAS PROC COMPARE to compare data sets in two folders.

What do I need?

Data sets to be compared must be in two folders. You must also specify a Compare Parameters Data Set that lists the names of the data sets to compare, the variables , and the tolerance.

For a simple illustration, place the following data set (named A.sas7bdat ) in the first folder.

Place the following data set ( also named A.sas7bdat ) in the second folder. Notice the differences from the previous data set.

Finally, specify compareparameters.sas7bdat as the Compare Parameters Data Set , which is shown below .

For detailed information about the files and data sets used or created by JMP Life Sciences software, see Files and Data Sets .

Output/Results

The output of this process consists of a Results window containing SAS output. Detailed comparison statistics are given for each observation .

Partial example output is shown below . Annotations have been made in red . Notice that the extra variable, extra observation, and value differences have been detected.