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

[in]librefLibref of the library to create DDL for. Should already be assigned.
[in]dsdataset to create ddl for (optional)
[in]fref=(getddl) the fileref to which to append the DDL. If it does not exist, it will be created.
[in]flavour=(SAS) The type of DDL to create. Options:
  • SAS
  • TSQL

Definition in file