%MM_CreateModelDataset Macro

Creates a data set that contains information about models. SAS Decision Manager can provide information for the champion model or for all models that are in the specified model repository path. The repository path that you specify can be MMRoot, an organizational folder, a project, a version, or a model. The data set contains the information for models that exist under the specified path.

Syntax

%MM_CreateModelDataset (mDatasetName = name-of-data-set,
smmPath=folder-project-verion-or-model-path <isChampion=Y | N><, Trace=ON | OFF>);

Arguments

mDatasetName = name-of-data-set

specifies the name of the data set that the macro creates. The macro can be created in a data set that you specify by using a two-level name in the form libref.filename.

Default mDatasetName=work.models

smmPath=folder-project-version-or-model-path

specifies the path from which to obtain the model data. If the path is a folder, the data set contains model information for all models under that folder unless isChampion=Y. If isChampion=Y, the information that is returned is for only the champion model. If the path is a project, the data set contains model information for models under that project. If the path is a version, the data set contains model information for models under that version. If the path is a model, the data set contains model information for only that model.

Default MMRoot

isChampion=Y | N

specifies whether the information that is returned contains information for only the champion model or for all models.

Y specifies that the information that is returned is for only the champion model.
N specifies that the information that is returned is for all models.
Default Y

Trace=ON | OFF

specifies whether to supply verbose trace messages to the SAS log.

Default OFF
Example Trace=on

Details

By default, the %MM_CreateModelDataset returns data only about the champion model. If you want information about models other than the champion model, specify isChampion=N. The data set that is created contains these variables:
Algorithm Name ScoreCodeType
CreationDate Owner Template
Description ProductionDate TemplateFileName
ExpirationDate ProjectName Tool
FolderName ProjectPath UserProperties
Function ProjectState VersionName
ModelLabel ProjectURL VersionState
ModelUUID ProjectUUID isChampion
Modeler PublishedDate isDefaultVersion
ModificationDate RetiredDate isPublished

Example

Extracting Model Information
/*****************************************************/
/* Create a data set to contain model information    */
/*****************************************************/

Options nomlogic nomprint nospool;

/*****************************************************/
/* Load and access the Model Management macro code. */
/*****************************************************/

Filename MMAccess catalog 'SASHELP.modelmgr.AccessMacros.source';
%include MMAccess;

/* Fileref to the encoded password                   */

FILENAME pwfile 'my-network-path\pwfile'; 

/*****************************************************/
/* Set the SAS WIP Server variables.                  */
/*****************************************************/

%let _MM_Service_Registry_URL=
   %STR(http://abcdef.sas.com:7980/SASWIPClientAccess/remote/ServiceRegistry); 
%let _MM_User = miller;
data _null_;
   infile pwfile obs=1 length=l; 
   input @;
   input @1 line $varying1024. l; 
   call symput('_MM_Password',substr(line,1,l)); 
run;
/******************************************************/
/* Specify the location of the data set and model     */ 
/* path.                                              */
/******************************************************/

libname modelDS 'c:\myModel\ModelInfo';
%let hmeq2013 = //ModelManagerModelRepos/MMRoot/HomeEquity/HMEQ/2013;

/******************************************************/
/* Set to detect failure in case macro load fails     */
/* and create the model data set.                     */
/******************************************************/

%let _MM_RC= -1; 

%MM_CreateModelDataset(mDatasetName=modelDS.models, 
    smmpath=//ModelManagerDefaultRepo/MMRoot/DDHMEQ/HMEQ/2013/Models/
              Regression,
    Trace=ON);

/****************************************************/
/* Display the defined variables. */
/****************************************************/

Options nosource;
%PUT _MM_RC = &_MM_RC;
Options source;