Macros for SAS Application Developers
No Matches 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;


libname demo "/lib/directory";

Or, to just create them in WORK:


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

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

Related Files

Allan Bowe

Definition in file