Production Ready Macros for SAS Application Developers
https://github.com/sasjs/core
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.

dbml for sas

SAS Macros

Parameters
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)
Version
9.3
Author
Allan Bowe

Definition in file mp_getdbml.sas.