How It Works

By using the SAS formats publishing macro, you can generate a SAS_PUT() function that enables you to execute PUT function calls inside the database. You can reference the formats that SAS supplies and most custom formats that you create by using PROC FORMAT.

The SAS formats publishing macro takes a SAS format catalog and publishes it to the database. Inside the database, a SAS_PUT() function, which emulates the PUT function, is created and registered for use in SQL queries.

Process Flow Diagram

Here is the basic process flow.

1 Install the components that are necessary for in–database processing.

For more information, see Deployed Components for In-Database Processing.

Note: This is a one-time installation process.

2If necessary, create your custom formats by using PROC FORMAT and create a permanent catalog by using the LIBRARY= option.

For more information, see the topic on user-defined formats in the section for your database.

3 Start SAS 9.3 and run the format publishing macro. This macro creates the files that are needed to build the SAS_PUT() function and publishes those files to the database.

For more information, see the topic on publishing SAS formats in the section for your database.

4After the format publishing macro creates the script, SAS/ACCESS Interface to Teradata executes the script and publishes the files to the database.

For more information, see the topic on publishing SAS formats in the section for your database.

5The SAS_PUT() function is available to use in any SQL expression and to use typically wherever you use your database’s built-in functions.

For more information, see the topic on using the SAS_PUT() function in the section for your database.