Macros for SAS Application Developers
https://github.com/sasjs/core
Loading...
Searching...
No Matches
mp_dictionary.sas File Reference

Creates a portal (libref) into the SQL Dictionary Views. More...

Go to the source code of this file.

Detailed Description

Provide a libref and the macro will create a series of views against each view in the special PROC SQL dictionary libref.

This is useful if you would like to visualise (navigate) the views in a SAS client such as Base SAS, Enterprise Guide, or Studio (or Data Controller).

It works by extracting the dictionary.dictionaries view into YOURLIB.dictionaries, then uses that to create a YOURLIB.{viewName} for every other dictionary.view, eg:

proc sql;
create view YOURLIB.columns as select * from dictionary.columns;

Usage:

libname demo "/lib/directory";
%mp_dictionary(lib=demo)

Or, to just create them in WORK:

%mp_dictionary()

If you'd just like to browse the dictionary data model, you can also check out this article.

Parameters
[in]lib=(WORK) The libref in which to create the views

Related Files

Version
9.2
Author
Allan Bowe

Definition in file mp_dictionary.sas.