Macros for SAS Application Developers
https://github.com/sasjs/core
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.