difftest
Verify differences among SAS datasets
    %difftest (fpath_a ... fpath_z = format path,
               path_a ... path_z = path to the SAS data,
               dat_a1...dat_z100 = dataset name);
Where | Is Type... | And represents...
fpath_a - fpath_z | C (200 chars) | Path location to the format catalog which contains user defined formats for the data.
path_a - path_z | C (200 chars) | Physical path location to SAS data used for verification.
dat_a1 - dat_a100 ... dat_z1 - dat_z100 | C (8 chars) | SAS dataset name which will be used for verification. Note that the alpha variable following the "dat_" matches with the name of the path parameter. If an asterisk is specified as a wildcard, all datasets within the specified path will be selected.
Details This tool verifies the structure of selected SAS datasets. It will ensure standards and integrity of the data. The types of verification which will be tested include: For variables with the same name across different datasets, %difftest will verify that the following attributes are the same: Type Length Label Format Name Informat Name For variable labels that are the same, %difftest will verify if the corresponding variable names are the same. For format names that are the same, %difftest will verify if the coded values of the formats are the same. For format codes that are the same, %difftest will verify if the format names are the same. For dataset names that are the same, %difftest will verify if the dataset labels are the same. For dataset labels that are the same, %difftest will verify if the dataset names are the same. For variables with coded formats, %difftest will verify if the values of the variables match up with the specified format codes. Note that format codes cover all the data that is found in the format with the exception of "other". A report will be generated detailing any findings in the SAS output. The results are also stored in SAS datasets in the work area with the names difft1...difft7, corresponding to the checks mentioned above. Example
    %difftest (fpath_a=c:\my\format\location,
             path_a=c:\my\data\path,
             dat_a1=demog,
             dat_a2=ae);
    %difftest (fpath_a=c:\my\format\location_a,
             fpath_b=c:\my\format\location_b,
             path_a=c:\my\data\path,
             path_b=c:\my\data\path,
             dat_a1=demog,
             dat_b1=ae);
    %difftest (path_a=c:\my\data\path,
             dat_a1=*);