![]() |
Production Ready Macros for SAS Application Developers
https://github.com/sasjs/core
|
Creates constraints. More...
Go to the source code of this file.
Takes the output from mp_getconstraints.sas as input
proc sql; create table work.example( TX_FROM float format=datetime19., DD_TYPE char(16), DD_SOURCE char(2048), DD_SHORTDESC char(256), constraint pk primary key(tx_from, dd_type,dd_source), constraint unq unique(tx_from, dd_type), constraint nnn not null(DD_SHORTDESC) ); %mp_getconstraints(lib=work,ds=example,outds=work.constraints) %mp_deleteconstraints(inds=work.constraints,outds=dropped,execute=YES) %mp_createconstraints(inds=work.constraints,outds=created,execute=YES)
inds= | The input table containing the constraint info |
outds= | a table containing the create statements (create_statement column) |
execute= | YES|NO - default is NO. To actually create, use YES. |
Definition in file mp_createconstraints.sas.