SAS_SCORE() Function

Overview of the SAS_SCORE() Function

The SAS_SCORE() function executes the scoring model using the SAS Embedded Process in Aster nCluster. The SAS_SCORE() function is deployed and stored in the NC_INSTALLED_FILES table under the PUBLIC schema during the installation and configuration of the SAS Scoring Accelerator for Aster nCluster. For more information, see Overview of Deployed Components for In-Database Processing.

Using the SAS_SCORE() Function

The SAS_SCORE() function is available to use in the FROM clause in any SQL expression in the same way that Aster nCluster SQL/MR functions are used.

The syntax of the SAS_SCORE() function is as follows:

FROM SAS_SCORE(ON input-table MODEL('model-name'))

Arguments

input-table

specifies the input table that is used by the SAS_SCORE() function.

model-name

specifies the name of the model. The value of this argument is the same as the value of MODELNAME=name argument for the %INDAC_PUBLISH_MODEL macro.

Here is an example of using the SAS_SCORE function. In this example, the input table is score_intab and the model name is reg.

select id, em_classification, em_eventprobability, em_probability 
   from sas_score (on score_intab model('reg'));