%MM_PublishPortfolioModelsDB

The %MM_PublishPortfolioModelsDBmacro is used for publishing models from a portfolio to a database.

Requirement:

The macro is limited to publishing the project champion models whose score code type is DATA step. The publishing of SAS analytic store models is not currently supported.

Syntax

Required Arguments

Example

Syntax

%MM_PublishPortfolioModelsDB (

dbType=database-type,

dbServer=database-server,

dbUser=database-user,

dbPassword=database-password,

database=database-name,

modelDS=sas-dataset-name,

outputDir=output-directory-path

);

Required Arguments

dbType=database-type

Specifies the type of database (for example, Teradata).

dbServer=database-server

Specifies the name of the database server.

dbUser=database-user

Specifies the user name for the database.

dbPassword=database-password

Specifies the password for the database user.

modelDS=SAS-dataset-name

Specifies the name of the model property SAS data set that is generated from the %MM_CreateModelDataset macro.

outputDir=output-directory-path

Specifies the directory path where to store the publish results.

Example: Publish Models to a Database

This example shows how to publish the champion models of a SAS Model Manager portfolio to Teradata.

filename pubdb catalog 'SASHELP.modelmgr.MM_PublishPortfolioModelsDB.source';
%include pubdb ;
filename pubdb ;
 
%let Database=myDatabase;
%let dbType=Teradata;
%let Server=myTeradataServer;
%let User = %nrbquote(myDatabaseUserName);
%let Password = %nrbquote(myDatabasePassword);
 
%MM_PublishPortfolioModelsDB(
    dbType =&dbType ,
    dbServer =&Server,
    dbUser =&User,
    dbPassword=&Password,
    database =&Database,
    modelDS=_models,
    outputDir=%nrstr(C:\temp\FMScore)
);

Last updated: February 14, 2017