mp_createconstraints.sas File Reference

Creates constraints. More...

Go to the source code of this file.

Detailed Description

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)

Parameters

[in]	inds=	(work.mp_getconstraints) The input table containing the constraint info
[out]	outds=	(work.mp_createconstraints) A table containing the create statements (create_statement column)
[in]	execute=	(NO) To actually create, use YES.

Related Files

• mp_getconstraints.sas

Version

9.2

Author

Allan Bowe

Definition in file mp_createconstraints.sas.