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

• mp_dictionary.test.sas

Version

9.2

Author

Allan Bowe

Definition in file mp_dictionary.sas.