Data Management

PROC COMPARE - Worth Another Look!

Download Now Date Added: Mar 2010
Format: PDF

PROC COMPARE is one of those workhorse procedures in the Base SAS closet that deserves to be dusted off, tuned up and pressed into service again! With well-chosen PROC COMPARE options and statements, one can compare pairs of SAS datasets at multiple levels without the need for DATA step MERGEs or SQL JOINs. Specifically, one can identify differences and similarities across SAS data sets with respect to: data set attributes; variable existence and attributes; existence of matching observations; and variable values (at user-specified levels of precision). This handy PROC can even be used to compare values of one variable to another within a dataset. Additionally, several different reporting options are available and can be customized to project needs.