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.

Note - views are not currently supported.

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)

SAS Macros

• mf_existfileref.sas
• mf_getvarcount.sas
• mp_getconstraints.sas

Parameters

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 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

Version

9.3

Author

Allan Bowe

Definition in file mp_getddl.sas.