Extracting the Champion Model from a Channel

Using the %MM_GetModels() Macro

Before you run the %MM_RunReports() macro, you must extract the model from the publishing channel to the SAS Model Manager server. The model must have been published to the channel from the project folder. The %MM_GetModels() macro extracts models and auxiliary files from a SAS Publishing Framework SPK file to the SAS Model Manager server. All models that were published to the specified channel are included in the SPK file for a given modeling project. If a model has been published multiple times over the channel, the latest model is used in the extraction. The macro then extracts the files from the SPK file to their respective folders on the SAS Model Manager server. The auxiliary files are extracted to the model folder and the model score code is extracted to a folder named \scorecode, which the macro creates as a subfolder of the model folder.
Note: You can run the %MM_GetModels() macro when no new model has been published to the channel for a modeling project.
The auxiliary files include three SAS data sets:
  • current.sas7bdat contains project and model metadata
  • logs.sas7bdat contains the SAS logs that were created during the model extraction process
  • processingspk.sas7bdat contains information that is necessary to process the SPK file
The models in the \scorecode folder are named using the project UUID as the model folder name. The %MM_RunReports() macro uses the mm_jobs.project data set to determine the project UUID. The project UUID is then used as the name of the model on the SAS Model Manager server for scoring when the performance monitoring reports are created.
The current data set contains project and model information and is used by the %MM_RunReports() macro. To ensure that the %MM_RunReports() macro is using the most current project and model metadata, always run the %MM_GetModels() macro before you run the %MM_RunReports() macro. For a list of the information that is contained in the current data set, see The current.sas7bdat Data Set.

Accessing Model Management Report Macros

The %MM_RunReports() macro, the %MM_GetModel() macro, and all other Model Management macros are available in the catalog sashelp.modelmgr.reportmacros.source. Use the following FILENAME statement to make these macros available to your program:
filename repmacro catalog 'sashelp.modelmgr.reportmacros.source';
%inc repmacro;

%MM_GetModels() Macro Syntax

Here is the syntax for the %MM_GetMacros() macro:
%MM_GetModels(channel=channelPathlocalPath=localModelPath);
channel=channelPath
specifies the path of the channel to extract the models from. To obtain the channel path, see Determine the Publish Channel. Do not enclose the value of channel in quotation marks.
Note: The %MM_GetModels() macro supports only publishing channels that have a persistent store type of Archive.
localPath=localModelPath
specifies a folder on the SAS Model Manager server to where the model and auxiliary files are extracted from the SPK file. Do not enclose localModelPath in quotation marks.

Example Program to Extract a Model from a Channel

The following SAS code uses the %MM_GetModel macro to extract a champion model from a channel.
/* Source file name: sashelp.modelmgr.reportExample1.source */

FILENAME mmmac 
  catalog 'sashelp.modelmgr.reportmacros.source';
%inc mmmac;

%MM_GetModels(
  channel=\\network1\MMChampion\channel1,
  localPath=c:\mm.test\model.extraction);

The current.sas7bdat Data Set

When models are extracted from a publishing channel, the current.sas7bdat data set contains the following information for each model:
Variable Name for the Project or Model Information
Description
algorithm
The algorithm that was used to create the model
fileName
Not used
isChampionModel
True or False to indicate whether the model is the champion model
keyWords
Keywords
miningFunction
The type of mining function, such as classification, prediction, segmentation
model
Not used
modeler
The name of the person who created the model
modelName
The name of the model
modelProductionTimestamp
The time at which the model was declared as a production model
modelTool
The name of the tool that was used to train the model
modelUUID
The UUID for the model
nodeDescription
Not used
projectPath
The project URL
project UUID
The UUID for the project
repository
The repository URL
scoreCodeType
DATA step or SAS program
subject
The subject name
targetName
The Training target variable name
userAttr
User-defined attributes, such as "MODELER='sasguest' MODELPROJECTVARMAP='predictedProbability eq P_BAD1; predictedClass eq I_BAD;' "
versionName
The name of the version that contains the model
whenPublished
The date and time at which the project or model was published to the channel
whoPublished
The user who published the model
Last updated: February 22, 2017