mp_getdbml.sas 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: https://www.dbml.org/home/

Usage:

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

Take the log output and paste it into the renderer at https://dbdiagram.io 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.

SAS Macros

• mf_getquotedstr.sas
• mp_getconstraints.sas

Parameters

[in]	liblist=	(SASHELP) Space seperated list of librefs to take as input
[out]	outref=	(getdbml) Fileref to contain the DBML
[in]	showlog=	(NO) set to YES to show the DBML in the log

Version

9.3

Author

Allan Bowe

Definition in file mp_getdbml.sas.