Production Ready Macros for SAS Application Developers
https://github.com/sasjs/core
mp_getddl.sas File Reference

Extract DDL in various formats, by table or library. More...

Go to the source code of this file.

Detailed Description

Data Definition Language relates to a set of SQL instructions used to create tables in SAS or a database. The macro can be used at table or library level. The default behaviour is to create DDL in SAS format.

Usage:

data test(index=(pk=(x y)/unique /nomiss));
  x=1;
  y='blah';
  label x='blah';
run;
proc sql; describe table &syslast;
%mp_getddl(work,test,flavour=tsql,showlog=YES)

Dependencies

Parameters
liblibref of the library to create DDL for. Should be assigned.
dsdataset to create ddl for (optional)
fref=the fileref to which to write the DDL. If not preassigned, will be assigned to TEMP.
flavour=The type of DDL to create (default=SAS). Supported=TSQL
showlog=Set to YES to show the DDL in the log
schema=Choose a preferred schema name (default is to use actual schema ,else libref)
applydttm=for non SAS DDL, choose if columns are created with native datetime2 format or regular decimal type
Version
9.3
Author
Allan Bowe

Definition in file mp_getddl.sas.