|
Match variable names and
labels if they are similar %matchvar (path_a ... path_z = path to the SAS data,
dat_a1...dat_z100 = dataset name,
score = tolerance score,
title = title for report,
output= output file);
|
Where |
Is Type... |
And represents... |
| 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. |
| score | N (8 Optional) | The
tolerance score controls how closely the match criteria is.
The range can be 1 up to 5. A small value of 1 means a very
close tight match. A larger number of 5 means that even if the
match is not exact, it will consider it a match. If not
specified, a value of 3 is defaulted. |
| title | C (200 Optional) | A
descriptive title that will be displayed at the top of all
reports. |
| output | C (200 Optional) | Output
name for html file. | Details
This
tool compares variable names and variable labels. It will then
recommend those that it finds a close match. If only one directory
path is specified, it will compare all the variables among the dataset
within that one path. If more than one path is specified, it will
only show results from variables among different paths. This means
that it will not compare variables within the same path in the case of
multiple paths.
Example %matchvar (path_a=c:\my\data\path,
dat_a1=demog,
dat_a2=ae);%matchvar (path_a=c:\my\data\path,
path_b=c:\my\data\path,
dat_a1=demog,
dat_b1=ae);
%matchvar (path_a=c:\my\data\path,
dat_a1=*);
%matchvar (path_a=c:\my\data\path,
path_b=c:\my\data\path,
dat_a1=demog,
dat_b1=ae,
output=c:\temp\matchvar.html);
|
