Macros for SAS Application Developers 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.

Note - views are not currently supported.


data test(index=(pk=(x y)/unique /nomiss));
  label x='blah';
proc sql; describe table &syslast;

SAS Macros

liblibref of the library to create DDL for. Should be assigned.
dsdataset to create ddl for (optional)
fref=the fileref to which to append the DDL. If it does not exist, it will be created.
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
Allan Bowe

Definition in file