The
SAS publishing macros are used to publish formats and the SAS_PUT( )
function in the Teradata EDW.
The
%INDTD_PUBLISH_FORMATS macro creates the files
that are needed to build the SAS_PUT( ) function and publishes
these files to the Teradata EDW.
The
%INDTD_PUBLISH_FORMATS macro also publishes the
formats that are included in the SAS formats library. This makes many
formats that SAS supplies available inside Teradata.
For more information
about the SAS formats library, see Deployed Components for Teradata.
In addition to formats
that SAS supplies, you can also publish the PROC FORMAT definitions
that are contained in a single SAS format catalog by using the FMTCAT=
option. The process of publishing a PROC FORMAT catalog entry converts
the range label pairs into embedded data in Teradata. For more information
about value-range-sets, see PROC FORMAT in the
Base SAS Procedures Guide.
Note: If you specify more than
one format catalog using the FMTCAT= option, the last format that
you specify is the one that is published. You can have only one formats
library active in the Teradata database.
The
%INDTD_PUBLISH_FORMATS macro performs the following
tasks:
-
creates .h and .c files, which
are necessary to build the SAS_PUT( ) function
-
produces a script of Teradata commands
that are necessary to register the SAS_PUT( ) function in the
Teradata EDW
-
uses
SAS/ACCESS Interface to Teradata to execute the script and publish
the files to the Teradata EDW