Production Ready Macros for SAS Application Developers File Reference

Extract DBML from SAS Libraries. More...

Go to the source code of this file.

Detailed Description

DBML is an open source markup format to represent databases. More details:


%mp_getdbml(liblist=SASHELP WORK,outref=mydbml,showlog=YES)

Take the log output and paste it into the renderer at to view your data model diagram. The code takes a "best guess" at the one to one and one to many relationships (based on constraints and indexes, and assuming that the column names would match).

You may need to adjust the rendered DBML to suit your needs.

dbml for sas

SAS Macros

liblist=Space seperated list of librefs to take as input (Default=SASHELP)
outref=Fileref to contain the DBML (Default=getdbml)
showlog=set to YES to show the DBML in the log (Default is NO)
Allan Bowe

Definition in file