|
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,
title = title for report);
|
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. |
|
title | C (200
Optional) | A
descriptive title that will be displayed at the top of all reports. | 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=*);
|
