mm_getlibmetadiffs.sas File Reference

Compares the metadata of a library with the physical tables. More...

Go to the source code of this file.

Detailed Description

Creates a series of output tables that show the differences between metadata and physical tables. Each output can be created with an optional prefix.

Credit - Paul Homes https://platformadmin.com/blogs/paul/2012/11/sas-proc-metalib-ods-output

Usage:

%* create (and assign) a library for testing purposes ;
%mm_createlibrary(
  libname=My Temp Library,
  libref=XXTEMPXX,
  tree=/User Folders/&sysuserid,
  directory=%sysfunc(pathname(work))
)

%* create some tables;
data work.table1 table2 table3;
  a=1;b='two';c=3;
run;

%* register the tables;
proc metalib;
  omr=(library="My Temp Library");
  report(type=detail);
  update_rule (delete);
run;

%* modify the tables;
proc sql;
drop table table3;
alter table table2 drop c;
alter table table2 add d num;

%* run the macro;
%mm_getlibmetadiffs(libname=My Temp Library)

%* delete the library ;
%mm_deletelibrary(name=My Temp Library)

The program will create four output tables, with the following structure (and example data):

&prefix.added

name:$32.	metaID:$17.	SAStabName:$32.
		DATA1

&prefix.deleted

name:$32.	metaID:$17.	SAStabName:$32.
TABLE3	A5XLSNXI.BK0001HO	TABLE3

&prefix.updated

tabName:$32.	tabMetaID:$17.	SAStabName:$32.	metaName:$32.	metaID:$17.	sasname:$32.	metaType:$16.	change:$64.
TABLE2	A5XLSNXI.BK0001HN	TABLE2	c	A5XLSNXI.BM000MA9	c	Column	Deleted
			d		d	Column	Added

&prefix.meta

Label1:$28.	cValue1:$1.	nValue1:D12.3
Total tables analyzed	4	4
Tables to be Updated	1	1
Tables to be Deleted	1	1
Tables to be Added	1	1
Tables matching data source	1	1
Tables not processed	0	0

If you are interested in more functionality like this (checking the health of SAS metadata and your SAS 9 environment) then do contact Allan Bowe for details of our SAS 9 Health Check service.

Our system scan will perform hundreds of checks to identify common issues, such as dangling metadata, embedded passwords, security issues and more.

Parameters

[in]	libname=	the metadata name of the library to be compared
[out]	outlib=(work)	The library in which to store the output tables.
[out]	prefix=(metadiff)	The prefix for the four tables created.

Version

9.3

Author

Allan Bowe

Definition in file mm_getlibmetadiffs.sas.