mm_gettables.sas File Reference

Creates a dataset with all metadata tables for a particular library. More...

Go to the source code of this file.

Detailed Description

Will only show the tables for which the executing user has the requisite metadata access.

usage:

%mm_gettables(uri=A5X8AHW1.B40001S5)

Parameters

[in]	uri=	the uri of the library for which to return tables
[out]	outds=	(work.mm_gettables) the dataset to contain the list of tables
[in]	getauth=	(YES) Fetch the authdomain used in database connections. Set to NO to improve runtimes in larger environments, as there can be a performance hit on the metadata_getattr(domainuri, "Name", AuthDomain) call.

Returns

outds dataset containing all groups in a column named "metagroup" (defaults to work.mm_getlibs). The following columns are provided:

• tablename
• tableuri
• libref
• libname
• libdesc

Version

9.2

Author

Allan Bowe

Definition in file mm_gettables.sas.