The %INDAC_PUBLISH_MODEL
macro produces three scoring files for each model:
-
sasscore_
modelname.ds2.
This file contains code that is executed by the SAS_SCORE()
function.
-
sasscore_
modelname_io.xml.
This file contains the scoring model's input and output variables.
-
sasscore_
modelname_ufmt.xml.
This file contains user-defined formats for the scoring model that
is being published.
For Aster 4.5, these files are stored in the
NC_INSTALLED_FILES table under
the PUBLIC schema. For Aster
nCluster
4.6, these files are stored in the NC_USER_INSTALLED_FILES table under
the schema that you specified in the INDCONN macro variable.
See Scoring File Examples for an example
of each of these files.Note: When you publish a model
using Aster 4.5, you are likely to receive warnings about multiple
lengths and unbalanced quotation marks. This warning does not keep
the model from being published successfully. The error occurs because
the .ds2 scoring file is inserted into an Aster system table as a
long quoted string.
There
are four ways to see the scoring files that are created:
-
Log on to the database using the
Aster command line processor and submit an SQL statement. The following
example assumes that the model name that you used to create the scoring
files is
reg.
>act -h hostname -u username -w password -d databasename
>select name from nc_user_installed_files where name like '%sasscore_reg%';
Three files are listed
for each model:
name
-------------------------
sasscore_reg.ds2
sasscore_reg_io.xml
sasscore_reg_ufmt.xml
-
From SAS, use SQL procedure code
that produces output in the LST file. The following example assumes
that the model name that you used to create the scoring functions
is
reg.
proc sql noerrorstop;
connect to aster (user=username password=password dsn=dsnname);
select *
from connection to aster
(select filename, fileowner, uploadtime
from nc_user_installed_files where
name like 'sasscore_reg%');
disconnect from aster;
quit;
-
Look at the SampleSQL.txt file
that is produced when the
%INDAC_PUBLISH_MODEL macro is successfully run. This file can be found
in the output directory (OUTDIR argument) that you specify in the
%INDAC_PUBLISH_MODEL macro.
The SampleSQL.txt file
contains basic code that, with modifications, can be used to run your
score code inside Aster.
Note: The function and table names
must be fully qualified if the functions and tables are not in the
same database.
For example, the SampleSQL.txt
file refers to an ID column in
score_outtab that
is populated with a unique integer from 1 to
n,
with
n being the number of
rows in the table. The ID column uniquely identifies each row. You
would replace the ID column with your own primary key column.
The following example
assumes that the model name that you used is
reg.
drop table score_outtab;
create table score_outtab(
id integer
,"EM_CLASSIFICATION" varchar(256)
,"EM_EVENTPROBABILITY" float
,"EM_PROBABILITY" float
);
insert into score_outtab(
id
,"EM_CLASSIFICATION"
,"EM_EVENTPROBABILITY"
,"EM_PROBABILITY"
)
select id,
"EM_CLASSIFICATION",
"EM_EVENTPROBABILITY",
"EM_PROBABILITY"
from sas_score(on score_intab model('reg'));
-
Look at the SAS log that is created
when the %INDAC_PUBLISH_MODEL macro was run. A message that indicates
whether the scoring files are successfully or not successfully created
is printed to the SAS log.