Transdata™ - finddup

 

Finds duplicate variable names in the transformation models

%finddup (modlib = library for models,
                     output = output report);


Where Is Type... And represents...
modlib C SAS library name containing the models stored as SAS datasets.
output C (optional) Output report name.  If none is specified, the default report name is finddup.html stored at the current location.  There are two reports that are generated. 

Details
This tool analyzes all the models specified at a specified libname.  It will search for duplicate transformed variable names in the "Update To" field.  Whenever there is the same variable name mentioned twice, it will capture and generate a report.  The report will contain the following information:

  • Transformed variable name.
  • Update to specification
  • Original variable name
  • Source dataset name
  • Destination dataset name

A second report is generated will be generated listing the findings of each duplicate variable side by side.  It will list the original source variable and merge them if they are on different datasets.  The merge by field will be USUBJID. 
  • The libname TRANSLIB needs to be defined prior the use of %finddup.  This libname points to the administrative dataset that manages the models of the transformation as managed by Transdata.
  • If the transformation uses a particular libname to reference its data, it is required that you define that same libname pointing to the same location.

Example

%finddup (modlib = mylib,
                     output =
c:\temp\findddup.html);
 
    Transdata - ETL CDISC Software,  Meta-Xceed Inc.© 2009
Bookmark and Share