User-Defined Functions and the SAS Embedded Process

There are two methods by which formats and scoring models are processed inside the database:
  • user-defined functions
    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 DB2 under UNIX, Greenplum, Netezza, and Teradata.
  • SAS Embedded Process
    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 nCluster format publishing and scoring models, and for DB2, 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.
Copyright © SAS Institute Inc. All rights reserved.