![]() |
Production Ready Macros for SAS Application Developers
https://github.com/sasjs/core
|
Extract DDL in various formats, by table or library. More...
Go to the source code of this file.
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)
lib | libref of the library to create DDL for. Should be assigned. |
ds | dataset 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 |
Definition in file mp_getddl.sas.