filename repmacro catalog 'sashelp.modelmgr.reportmacros.source'; %inc repmacro;
libname
mm_jobs "c:\mmReports\HMEQ";
libname
mm_meta "c:\mmReports\HMEQ\model";
libname
scoreIn "c:\mmReports\project1\perfdatasets";
%let
_MM_JobLocalPath=c:\mmReports\HMEQ1;
%let
_MM_ModelLocalPath=c:\mmReports\HMEQ\model;
mapTable=mm_meta.current
.
The data set name current
is arbitrary.
It is recommended that you use the name current
.
%let
_MM_ReportMode=TEST;
filename pwfile "my-network-path\pwfile";
proc pwencode in="12345" out=pwfile;
run;
filename pwfile "my-network-path\pwfile";
%let _MM_User=mmuser1;
data _null_;
infile pwfile obs=1 length=l;
input @;
input @1 line $varying1024. l;
call symput('_MM_Password',substr(line,1,l));
run;
DATA libref.dataStepName; set libref.performanceDataSetName; run;
DATA scoreIn.hmeq; set scoreIn.hmeq_perf_q1; run;
scoreIn.hmeq0
.
The default value is used if you do not specify this argument when
calling this macro.
dataSource=mmlib.hmeq_perf_Q2
localPath=&_MM_ModelLocalPath
mapTable=&mapTable
user=&_MM_User
%MM_RunReports( dataSource=scoreIn.hmeq0, localPath=&_MM_ModelLocalPath, mapTable=&mapTable, user=&_MM_User, password=&_MM_Password);
/* Source file name: sashelp.modelmgr.reportExample4.source */ FILENAME repmacro catalog 'sashelp.modelmgr.reportmacros.source'; %inc repmacro; /* Fileref to the encoded password */ FILENAME pwfile "my-network-path\pwfile"; /**************************************************/ /* Specify the report execution metadata and */ /* configure the _MM_ macro variables to run the */ /* report job in TEST mode. */ /**************************************************/ %let _MM_ReportMode=TEST; %let _MM_User=mmuser1; data _null_; infile pwfile obs=1 length=l; input @; input @1 line $varying1024. l; call symput('_MM_Password',substr(line,1,l)); run; ; %let _MM_PathMayChange=Y; %let _MM_JobLocalPath=c:\mm.test\report.auto; %let _MM_ModelLocalPath=c:\mm.test\model.extraction; LIBNAME mm_jobs "&_MM_JobLocalPath"; LIBNAME mm_meta "&_MM_ModelLocalPath"; LIBNAME scoreIn 'c:\mm.test\score.in'; %let mapTable=mm_meta.current; /***************************************************/ /* DATA step scoreIn.hmeq0 */ /* */ /* First, run the Q4 report.It is necessary to */ /* artificially declare a "currentTime" argument */ /* of 01Jan2013 in order to trigger the report */ /* execution scheduled for the Q4 interval. */ /***************************************************/ %let currentTime=01Jan2013:12:30:15; %MM_RunReports( localpath=&_MM_JobLocalPath, currentTime=¤tTime, mapTable=&mapTable, user=&_MM_User, password=&_MM_Password); /***************************************************/ /* Now, run the Q1 report. It is necessary to */ /* artificially declare a "currentTime" argument */ /* of 03Apr2012 in order to trigger the report */ /* execution scheduled for the Q1 interval. */ /***************************************************/ %let currentTime=03Apr2012:12:30:15; %MM_RunReports( dataSource=scoreIn.hmeq_perf_q1, localpath=&_MM_JobLocalPath, currentTime=¤tTime, mapTable=&mapTable, user=&_MM_User, password=&_MM_Password); /***************************************************/ /* Now, run the Q2 report. It is necessary to */ /* artificially declare a "currentTime" argument */ /* of 03Jul2012 in order to trigger the report */ /* execution scheduled for the Q2 interval. */ /***************************************************/ %let currentTime=03Jul2012:12:30:15; %MM_RunReports( dataSource=scoreIn.hmeq_perf_q2, localpath=&_MM_JobLocalPath, currentTime=¤tTime, mapTable=&mapTable, user=&_MM_User, password=&_MM_Password); /***************************************************/ /* Now, run the Q3 report. It is necessary to */ /* artificially declare a "currentTime" argument */ /* of 03Oct2012 in order to trigger the report */ /* execution scheduled for the Q3 interval. */ /***************************************************/ %let currentTime=03Oct2012:12:30:15; %MM_RunReports( dataSource=scoreIn.hmeq_perf_q3, localpath=&_MM_JobLocalPath, currentTime=¤tTime, mapTable=&mapTable, user=&_MM_User, password=&_MM_Password); /***************************************************/ /* Now, run the Q4 report. It is necessary to */ /* artificially declare a "currentTime" argument */ /* of 03Jan2013 in order to trigger the report */ /* execution scheduled for the 2012Q4 interval. */ /***************************************************/ %let currentTime=03Jan2013:12:30:15; %MM_RunReports( dataSource=scoreIn.hmeq_perf_q4, localpath=&_MM_JobLocalPath, currentTime=¤tTime, mapTable=&mapTable, user=&_MM_User, password=&_MM_Password);