/*--------------------------------------------------------------
  *
  *                 SAS  TEST  LIBRARY
  *
  *      NAME:  migrate_template.sas
  *     TITLE:  template for MIGRATE validation programs
  *     LEVEL:  1
  *   SUPPORT:  David Wiehle david.wiehle@sas.com
  *     INPUT:
  *    OUTPUT:  migrate_template.log
  *             migrate_template.lst
  *  SPEC.REQ:  see below
  *--------------------------------------------------------------*/

  options nocenter formdlim='-';
  
  libname lib1 'path to source library';
  libname lib2 'path to target library';
  libname ods  'path used by macros';
  
  title1; 
  
  
  options nonotes;
  %before;  
  options notes;
  
  proc migrate in=lib1 out=lib2;run;
  
  options nonotes;
  %after;
 
  
  *------------------------------------------------------*
  * produce validation output for all the data sets which
  * only prints a listing of those attributes which
  * differ between the source and target libraries
  *------------------------------------------------------*;
  %checkdata;  
  *------------------------------------------------------*
  * produce validation output for all the data sets which
  * prints a listing of all data set attributes in the 
  * source and target libraries.
  *------------------------------------------------------*;
  ***%checkdata(showall=yes);
  
  *------------------------------------------------------*
  * produce validation output for all the audit files
  *------------------------------------------------------*;
  %checkaudit;
  ***%checkaudit(showall=yes); **print all Audit file information;

  *------------------------------------------------------*
  * produce validation output for all the catalogs 
  *------------------------------------------------------*;
  %checkcatalog;
  *------------------------------------------------------*
  * produce validation output for data step views and
  * SQL views.  WARNING:  not yet tested on libraries
  * which contain SAS/ACCESS views.  Use on these 
  * libraries at your own risk.  
  *------------------------------------------------------*;
  %checkview;
  ***%checkview(printview=yes);  ***print the first 10 obs in a view; 
  ***%checkview(printview=yes, obs=7);  **print a flexible number of obs ;
  

  *------------------------------------------------------*
  * OPTIONAL:
  * compare index and Integrity constraint information.
  *------------------------------------------------------*;
  %checkindex;
  ***checkindex(showall=yes);   **print the indexes and Integrity Constraints ;
  
  *------------------------------------------------------*
  * produce all of the above validation output
  *------------------------------------------------------*;
  ***%checkem;
  ***%checkem(showall=yes);

  options notes;
  

 /*--------------------------------------------------------------
  *
  *               SAS  TEST  LIBRARY  TRAILER
  *
  *   SYSTEMS:  9.1 or later
  *   PRODUCT:  MIGRATE
  *      KEYS:  
  *  COMMENTS:     
  *             
  *   CREATED:  3 November 2002.  dawieh.
  *    UPDATE:  9 December 2002   dawieh added %checkview                 
  *             19Februrary2003   dawieh added %before/%after
  *--------------------------------------------------------------*/