Production Ready 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 to which a user has the requisite metadata access.

usage:

mm_gettables(uri=A5X8AHW1.B40001S5)

Parameters
outdsthe dataset to create that contains the list of tables
urithe uri of the library for which to return tables
getauth=YES|NO - 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.