User-Defined Functions and the SAS Embedded Process

Formats and scoring models are converted by the publishing macros into scoring and format functions that are similar to any user-defined functions in the database.

In-database processing of formats and scoring models by means of user-defined functions is supported by Aster, DB2 under UNIX, Greenplum, Netezza, and Teradata.

The SAS Embedded Process is a SAS server process that is installed and runs inside the database to read and write data from the database. The advantage of using the SAS Embedded Process is that a single function or a stored procedure is used instead of multiple, user-defined functions.

The SAS Embedded Process is supported for Aster format publishing and scoring models, and for DB2, Greenplum, Oracle, and Teradata scoring models.

The SAS Embedded Process is one of the deployed components for in-database processing. For more information, see the SAS In-Database Products: Administrator's Guide.