The ASTORE Procedure

DESCRIBE Statement

  • DESCRIBE STORE=local-file-name <describe-options> ;

  • DESCRIBE RSTORE=CAS-libref.data-table <describe-options> ;

The DESCRIBE statement specifies the name or identifier of an analytic store either in the local file system by using the STORE= option or in a data table stored in CAS by using the RSTORE= option. The DESCRIBE statement can also produce DS2 basic scoring code. You can edit the basic scoring code to add transformations to the input variables, flag or override the decision made for the record, work with ensembles, and so on.

Because PROC ASTORE is interactive, you can edit the result from the DESCRIBE statement and send it in a subsequent SCORE statement. The edited file must comply with the DS2 language syntax. For more information about the DS2 language, see SAS DS2 Language Reference.

You must specify exactly one of the following options:

STORE=local-file-name

specifies either the file reference or the full path of a valid store file that was created earlier by another procedure that processed a SAVESTATE statement.

RSTORE=CAS-libref.data-table

specifies the CAS table that contains the analytic store. CAS-libref.data-table is a two-level name, where CAS-libref refers to the caslib and session identifier, and data-table specifies the name of the input data table. For more information about this two-level name, see the DATA= option and the section Using CAS Sessions and CAS Engine Librefs.

You can also specify the following describe-option:

EPCODE<=code-file-name>

sends DS2 language code either to the SAS log (if you do not specify a code-file-name) or to an external code file that can run in CAS and that is identified by code-file-name, which is either the file reference or the full path and member name of the external code file.

Note: The DS2 code enables you to score concurrently with multiple analytic stores as long as they share the same input and output variables. The store key identifier plays an important role in managing multiple analytic stores in a single run.

You can also specify the following describe-options in the order shown, if you want to copy some variables from the input data table to the output data table while scoring with the EPCODE= option:

DATA=CAS-libref.data-table

names the input data table for PROC ASTORE to use. CAS-libref.data-table is a two-level name, where

CAS-libref

refers to a collection of information that is defined in the LIBNAME statement and includes the caslib, which includes a path to the data, and a session identifier, which defaults to the active session but which can be explicitly defined in the LIBNAME statement. For more information about CAS-libref, see the section Using CAS Sessions and CAS Engine Librefs.

data-table

specifies the name of the input data table.

COPYVARS=variable | (variables)
COPYVAR=variable | (variables)

copies one or more variables from the input data table that you specify in the DATA= option to the output data table.

Note: The COPYVARS= option must follow the DATA= option.

Last updated: November 11, 2020