mp_ds2ddl.sas File Reference

Fetches DDL for a specific table. More...

Go to the source code of this file.

Detailed Description

Uses mp_getddl under the hood

Parameters

[in]	libds	library.dataset to create ddl for
[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
[in]

= (NO) Set to YES to show the DDL in the log

Parameters

[in]	schema=	() Choose a preferred schema name (default is to use actual schema, else libref)
[in]	applydttm=	(NO) For non SAS DDL, choose if columns are created with native datetime2 format or regular decimal type

SAS Macros

• mp_getddl.sas

Definition in file mp_ds2ddl.sas.