I'm new to the forum so i haven't worked out the quirks, but here is the data for the question i had previously.
37524 %dmcas_run_srv; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds WARNING: The content requested by the URL dmcas_httpGET was not found. WARNING: Variable VARIABLE_NAME has different lengths on BASE and DATA files (BASE 255 DATA 32). WARNING: Variable EVENT_VALUE has different lengths on BASE and DATA files (BASE 128 DATA 1). WARNING: Variable _Fmtvar_ has different lengths on BASE and DATA files (BASE 12 DATA 1). LIN X64 *------------------------------------------------------------* * Preparing the Training Table: _input_EDG0AU8FZS54GXG5THAJ8VRPQ *------------------------------------------------------------* property=modeling value=false property=component value=varselect property=modeling value=false property=component value=transform *------------------------------------------------------------* * Preparing the Training Metadata *------------------------------------------------------------* NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds *------------------------------------------------------------* * Initializing macro variables and variable macros *------------------------------------------------------------* *------------------------------------------------------------* * Executing Component code *------------------------------------------------------------* NOTE: PROCEDURE HTTP used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Fileref RSPHEAD has been deassigned. NOTE: Fileref RSPBODY has been deassigned. NOTE: PROCEDURE HTTP used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 3 The SAS System Sunday, March 31, 2024 10:25:00 PM NOTE: Fileref RSPHEAD has been deassigned. NOTE: Fileref RSPBODY has been deassigned. NOTE: JSON data is only read once. To read the JSON again, reassign the JSON LIBNAME. NOTE: Libref JSONLIB was successfully assigned as follows: Engine: JSON Physical Name: /opt/sas/v4e059/config/var/tmp/compsrv/default/4fa62989-d396-4df9-914b-2573c213c84c/SAS_work8EA100013656_pdcesx23104/respBody_ GetSummary_dmc_summary.json NOTE: Variable resourceId is uninitialized. NOTE: There were 1 observations read from the data set JSONLIB.ITEMS. NOTE: The data set WORK.HOLDER has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Fileref RSPBODY has been deassigned. NOTE: Libref JSONLIB has been deassigned. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: JSON data is only read once. To read the JSON again, reassign the JSON LIBNAME. NOTE: Libref JSONLIB was successfully assigned as follows: Engine: JSON Physical Name: /opt/sas/v4e059/config/var/tmp/compsrv/default/4fa62989-d396-4df9-914b-2573c213c84c/SAS_work8EA100013656_pdcesx23104/respBody_ GetSummary_dmc_summary.json NOTE: Variable resourceId is uninitialized. NOTE: There were 1 observations read from the data set JSONLIB.ITEMS. NOTE: The data set WORK.HOLDER has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Fileref RSPBODY has been deassigned. NOTE: Libref JSONLIB has been deassigned. NOTE: There were 1 observations read from the data set WORK.HOLDER. NOTE: The data set WORK.DMC_SUMMARY has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Deleting WORK.HOLDER (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 4 The SAS System Sunday, March 31, 2024 10:25:00 PM NOTE: There were 1 observations read from the data set WORK.DMC_SUMMARY. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Deleting WORK.DMC_SUMMARY (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Writing HTML5 Body file: ods.htm NOTE: Fileref _NN has been deassigned. NOTE: The file _TFREF is: Filename=/opt/sas/v4e059/config/var/tmp/compsrv/default/4fa62989-d396-4df9-914b-2573c213c84c/SAS_work8EA100013656_pdcesx23104/ f2c8f9cc-d166-4a7f-82a2-ecaf8ee7b20e/traincode.sas, Owner Name=carverwhite@cmail.carleton.ca, Group Name=v4e_users, Access Permission=-rw-r--r--, Last Modified=31Mar2024:22:25:34 NOTE: 26 records were written to the file _TFREF. The minimum record length was 3. The maximum record length was 84. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: External file /opt/sas/v4e059/config/var/tmp/compsrv/default/4fa62989-d396-4df9-914b-2573c213c84c/SAS_work8EA100013656_pdcesx23104/f2c8f9cc- d166-4a7f-82a2-ecaf8ee7b20e/scorecode.sas opened. NOTE: The procedure wrote the DATA step code to external file /opt/sas/v4e059/config/var/tmp/compsrv/default/4fa62989-d396-4df9-914b-2573c213c84c/SAS_work8EA100013656_pdcesx23104/f2c8f9cc- d166-4a7f-82a2-ecaf8ee7b20e/scorecode.sas. NOTE: The Cloud Analytic Services server processed the request in 0.051167 seconds. NOTE: The Cloud Analytic Services server processed the request in 0.005703 seconds. NOTE: The Cloud Analytic Services server processed the request in 0.005269 seconds. NOTE: The data set DMLIB.PREDINTONAME has 1 observations and 2 variables. NOTE: The data set DMLIB.PREDPROBNAME has 1 observations and 2 variables. NOTE: The data set DMLIB.ITERHIST has 1 observations and 6 variables. NOTE: The data set DMLIB.MODELINFO has 17 observations and 2 variables. NOTE: The data set DMCASLIB._EDG0AU8FZS54GXG5THAJ8VRPQ_MODEL has 151 observations and 11 variables. NOTE: PROCEDURE NNET used (Total process time): real time 0.11 seconds cpu time 0.06 seconds NOTE: Fileref _TFREF has been deassigned. 5 The SAS System Sunday, March 31, 2024 10:25:00 PM NOTE: Active Session now DMCASID. NOTE: 10 records were written to table histtable. {maxActions=156,firstShown=146,lastShown=155,actions={{ordinal=146,command= action table.columnInfo / table={name='_INPUT_EDG0AU8FZS54GXG5THAJ8VRPQ', caslib='Analytics_Project_381585fd-46b1-4c04-a0b6-eb579dee0b74'}, extended=true, sastypes=false; ,performance={elapsedTime=0.000602,cpuSystemTime=0.000299,cpuUserTime=0.000283,systemTotalMemory=540875538432,systemCores=36, systemNodes=1,memory=862880,memoryOS=15130624,memoryQuota=66801664,dataMovementTime=0,dataMovementBytes=0,responseSize=0, responseCount=0},disposition={severity=0,reason=0}},{ordinal=147,command=action sessionProp.getSessOpt / name='caslib';, performance={elapsedTime=0.000103,cpuSystemTime=0,cpuUserTime=0.000092,systemTotalMemory=540875538432,systemCores=36,systemNodes=1, memory=232576,memoryOS=15130624,memoryQuota=66801664,dataMovementTime=0,dataMovementBytes=0,responseSize=0,responseCount=0}, disposition={severity=0,reason=0}},{ordinal=148,command= action table.tableInfo / name='_EDG0AU8FZS54GXG5THAJ8VRPQ_MODEL', caslib='Analytics_Project_381585fd-46b1-4c04-a0b6-eb579dee0b74', quiet=true; ,performance={elapsedTime=0.000241,cpuSystemTime=9E-6,cpuUserTime=0.000162,systemTotalMemory=540875538432,systemCores=36, systemNodes=1,memory=318048,memoryOS=15130624,memoryQuota=66801664,dataMovementTime=0,dataMovementBytes=0,responseSize=0, responseCount=0},disposition={severity=0,reason=0}},{ordinal=149,command=action builtins.loadActionSet / actionSet='neuralNet';, performance={elapsedTime=0.001342,cpuSystemTime=0.001188,cpuUserTime=0.000141,systemTotalMemory=540875538432,systemCores=36, systemNodes=1,memory=247296,memoryOS=15130624,memoryQuota=66801664,dataMovementTime=0,dataMovementBytes=0,responseSize=0, responseCount=0},disposition={severity=0,reason=0}},{ordinal=150,command= action neuralNet.annTrain / table={name='_INPUT_EDG0AU8FZS54GXG5THAJ8VRPQ', caslib='Analytics_Project_381585fd-46b1-4c04-a0b6-eb579dee0b74', where='STRIP(PUT(_va_d__PARTITION3334__ONES, BEST.) ) ="1"'}, inputs={{name='AcceptedCmp1'}}, nominals={{name='AcceptedCmp1'}, {name='_va_d_Customer_Score_Indicat_1'}}, validTable={name='_INPUT_EDG0AU8FZS54GXG5THAJ8VRPQ', caslib='Analytics_Project_381585fd-46b1-4c04-a0b6-eb579dee0b74', where='STRIP(PUT(_va_d__PARTITION3334__ONES, BEST.) ) ="0"'}, target='_va_d_Customer_Score_Indicat_1', code={lineSize=120, fmtWdth=20, indentSize=3, labelId=68617390, noTrim=false, comment=false, tabForm=true, noCompPgm=true}, casOut={name='_EDG0AU8FZS54GXG5THAJ8VRPQ_MODEL', replace=true}, hiddens={50}, acts={'TANH'}, combs={'LINEAR'}, arch='MLP', missing='MEAN', targetAct='SOFTMAX', errorFunc='ENTROPY', std='MIDRANGE', seed=12345, randDist='UNIFORM', nTries=1, scaleInit=1, nloOpts={algorithm='lbfgs', optmlOpt={regL2=0.1, maxIters=300, fConv=1E-10}, sgdOpt={miniBatchSize=10}, lbfgsOpt=... ,performance={elapsedTime=0.051167,cpuSystemTime=0.046918,cpuUserTime=0.076528,systemTotalMemory=540875538432,systemCores=36, systemNodes=1,memory=11054464,memoryOS=25886720,memoryQuota=66801664,dataMovementTime=0,dataMovementBytes=0,responseSize=0, responseCount=0},disposition={severity=0,reason=0}},{ordinal=151,command= action neuralNet.annScore / table={name='_INPUT_EDG0AU8FZS54GXG5THAJ8VRPQ', caslib='Analytics_Project_381585fd-46b1-4c04-a0b6-eb579dee0b74', where='STRIP(PUT(_va_d__PARTITION3334__ONES, BEST.) ) ="1"'}, modelTable={name='_EDG0AU8FZS54GXG5THAJ8VRPQ_MODEL'}; ,performance={elapsedTime=0.005703,cpuSystemTime=0.003534,cpuUserTime=0.006421,systemTotalMemory=540875538432,systemCores=36, systemNodes=1,memory=2339328,memoryOS=18800640,memoryQuota=66801664,dataMovementTime=0,dataMovementBytes=0,responseSize=0, responseCount=0},disposition={severity=0,reason=0}},{ordinal=152,command= action neuralNet.annScore / table={name='_INPUT_EDG0AU8FZS54GXG5THAJ8VRPQ', caslib='Analytics_Project_381585fd-46b1-4c04-a0b6-eb579dee0b74', where='STRIP(PUT(_va_d__PARTITION3334__ONES, BEST.) ) ="0"'}, modelTable={name='_EDG0AU8FZS54GXG5THAJ8VRPQ_MODEL'}; ,performance={elapsedTime=0.005269,cpuSystemTime=0.003348,cpuUserTime=0.005573,systemTotalMemory=540875538432,systemCores=36, systemNodes=1,memory=2346720,memoryOS=18800640,memoryQuota=66801664,dataMovementTime=0,dataMovementBytes=0,responseSize=0, responseCount=0},disposition={severity=0,reason=0}},{ordinal=153,command=action sessionProp.getSessOpt / name='caslib';, performance={elapsedTime=0.000103,cpuSystemTime=0,cpuUserTime=0.000091,systemTotalMemory=540875538432,systemCores=36,systemNodes=1, memory=232576,memoryOS=18800640,memoryQuota=66801664,dataMovementTime=0,dataMovementBytes=0,responseSize=0,responseCount=0}, disposition={severity=0,reason=0}},{ordinal=154,command= action table.tableInfo / name='_EDG0AU8FZS54GXG5THAJ8VRPQ_MODEL', caslib='Analytics_Project_381585fd-46b1-4c04-a0b6-eb579dee0b74', quiet=true; ,performance={elapsedTime=0.000427,cpuSystemTime=0,cpuUserTime=0.000416,systemTotalMemory=540875538432,systemCores=36,systemNodes=1 ,memory=763488,memoryOS=18800640,memoryQuota=66801664,dataMovementTime=0,dataMovementBytes=0,responseSize=0,responseCount=0}, disposition={severity=0,reason=0}},{ordinal=155,command= action table.columnInfo / table={name='_EDG0AU8FZS54GXG5THAJ8VRPQ_MODEL', caslib='Analytics_Project_381585fd-46b1-4c04-a0b6-eb579dee0b74'}, extended=true, sastypes=false; ,performance={elapsedTime=0.000415,cpuSystemTime=0,cpuUserTime=0.000403,systemTotalMemory=540875538432,systemCores=36,systemNodes=1 ,memory=894816,memoryOS=18800640,memoryQuota=66801664,dataMovementTime=0,dataMovementBytes=0,responseSize=0,responseCount=0}, disposition={severity=0,reason=0}}}} NOTE: PROCEDURE CAS used (Total process time): 6 The SAS System Sunday, March 31, 2024 10:25:00 PM real time 0.00 seconds cpu time 0.00 seconds NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. NOTE: There were 10 observations read from the data set DMCASLIB.HISTTABLE. NOTE: The data set DMLIB.DMCAS_CASACTION has 1 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Variable id is uninitialized. NOTE: Variable engine is uninitialized. NOTE: Variable table_nm is uninitialized. NOTE: Variable revision is uninitialized. NOTE: The data set DMLIB.DMCAS_REGISTER has 1 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Cloud Analytic Services dropped table HISTTABLE from caslib Analytics_Project_381585fd-46b1-4c04-a0b6-eb579dee0b74. NOTE: Deleting DMCASLIB.HISTTABLE (memtype=DATA). NOTE: PROCEDURE DELETE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 1 observations read from the data set DMLIB.PREDPROBNAME. NOTE: There were 1 observations read from the data set DMLIB.PREDINTONAME. NOTE: The data set DMLIB.PREDNAMETABLE has 2 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 151 observations read from the data set DMCASLIB._EDG0AU8FZS54GXG5THAJ8VRPQ_MODEL. NOTE: The data set DMLIB.OUTMODEL has 151 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 150 observations read from the data set DMLIB.OUTMODEL. WHERE _nodetype_<=2; NOTE: The data set DMLIB.TOPINPUTWTS has 150 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 7 The SAS System Sunday, March 31, 2024 10:25:00 PM NOTE: There were 150 observations read from the data set DMLIB.TOPINPUTWTS. NOTE: The data set DMLIB.TOPINPUTWTS has 150 observations and 12 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 1 at 39364:101 NOTE: There were 1 observations read from the data set DMLIB.OUTMODEL. WHERE _nodetype_>2; NOTE: There were 150 observations read from the data set DMLIB.TOPINPUTWTS. NOTE: The data set DMLIB.WEIGHTS has 151 observations and 12 variables. NOTE: The data set DMLIB.OUTNODES has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 1 observations read from the data set DMLIB.OUTNODES. NOTE: The data set DMLIB.OUTNODES has 1 observations and 1 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 151 observations read from the data set DMLIB.WEIGHTS. NOTE: The data set DMLIB.TEMPSORTEDC has 151 observations and 11 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 151 observations read from the data set DMLIB.TEMPSORTEDC. NOTE: There were 1 observations read from the data set DMLIB.OUTNODES. NOTE: The data set DMLIB.OUTNODES has 1 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 151 observations read from the data set DMLIB.WEIGHTS. NOTE: The data set DMLIB.TEMPSORTED has 151 observations and 12 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Variable _varmean_ is uninitialized. 8 The SAS System Sunday, March 31, 2024 10:25:00 PM NOTE: There were 151 observations read from the data set DMLIB.TEMPSORTED. NOTE: There were 1 observations read from the data set DMLIB.OUTNODES. NOTE: The data set DMLIB.NODES has 53 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 50 observations read from the data set DMLIB.WEIGHTS. WHERE _layerid_=1; NOTE: The data set DMLIB.WTS has 50 observations and 12 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 50 observations read from the data set DMLIB.WTS. NOTE: The data set DMLIB.OUTPUTWTS has 1 observations and 4 variables. NOTE: The data set DMLIB.OTHERWTS has 49 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 49 observations read from the data set DMLIB.OTHERWTS. NOTE: There were 101 observations read from the data set DMLIB.WEIGHTS. WHERE _layerid_ not = 1; NOTE: The data set DMLIB.OTHERWTS has 150 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 150 observations read from the data set DMLIB.OTHERWTS. NOTE: The data set DMLIB.OTHERWTS has 150 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 1 observations read from the data set DMLIB.OUTPUTWTS. NOTE: There were 150 observations read from the data set DMLIB.OTHERWTS. NOTE: The data set DMLIB.WEIGHTS has 151 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 151 observations read from the data set DMLIB.WEIGHTS. NOTE: The data set DMLIB.WEIGHTS has 151 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds 9 The SAS System Sunday, March 31, 2024 10:25:00 PM cpu time 0.01 seconds NOTE: There were 53 observations read from the data set DMLIB.NODES. NOTE: The data set DMLIB.NODESS has 53 observations and 2 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 151 observations read from the data set DMLIB.WEIGHTS. NOTE: There were 53 observations read from the data set DMLIB.NODESS. NOTE: The data set DMLIB.WEIGHTS has 151 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 151 observations read from the data set DMLIB.WEIGHTS. NOTE: The data set DMLIB.WEIGHTS has 151 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 39364:188 NOTE: There were 151 observations read from the data set DMLIB.WEIGHTS. NOTE: There were 53 observations read from the data set DMLIB.NODESS. NOTE: The data set DMLIB.WEIGHTS has 151 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 151 observations read from the data set DMLIB.WEIGHTS. NOTE: There were 151 observations read from the data set DMLIB.WEIGHTS. NOTE: The data set DMLIB.NODESTOKEEP has 302 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 302 observations read from the data set DMLIB.NODESTOKEEP. NOTE: 248 observations with duplicate key values were deleted. NOTE: The data set DMLIB.NODESTOKEEP has 54 observations and 1 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 10 The SAS System Sunday, March 31, 2024 10:25:00 PM NOTE: There were 53 observations read from the data set DMLIB.NODES. NOTE: The data set DMLIB.NODES has 53 observations and 7 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 53 observations read from the data set DMLIB.NODES. NOTE: There were 54 observations read from the data set DMLIB.NODESTOKEEP. NOTE: The data set DMLIB.NODES has 54 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 54 observations read from the data set DMLIB.NODES. NOTE: The data set DMLIB.NODES has 54 observations and 7 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 54 observations read from the data set DMLIB.NODES. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 54 observations read from the data set DMLIB.NODES. NOTE: The data set DMLIB.NODES has 54 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The data set DMLIB.DMCAS_REPORT has 24 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Variable epoch is uninitialized. NOTE: There were 1 observations read from the data set DMLIB.ITERHIST. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 24 observations read from the data set DMLIB.DMCAS_REPORT. NOTE: The data set DMLIB.DMCAS_REPORT has 37 observations and 3 variables. NOTE: DATA statement used (Total process time): 11 The SAS System Sunday, March 31, 2024 10:25:00 PM real time 0.01 seconds cpu time 0.02 seconds NOTE: There were 37 observations read from the data set DMLIB.DMCAS_REPORT. NOTE: The data set DMLIB.DMCAS_REPORT has 48 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 48 observations read from the data set DMLIB.DMCAS_REPORT. NOTE: The data set DMLIB.DMCAS_REPORT has 59 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Fileref _DMCSFRF has been deassigned. NOTE: There were 0 observations read from the data set DMLIB.DMCAS_REGISTER. WHERE UPCASE(type)='CAS'; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds *------------------------------------------------------------* * Scoring table dmcaslib.'_input_EDG0AU8FZS54GXG5THAJ8VRPQ'n for assessment *------------------------------------------------------------* *------------------------------------------------------------* * Retrieving pipeline score code *------------------------------------------------------------* WARNING: Multiple lengths were specified for the BY variable NAME by input data sets. This might cause unexpected results. ERROR: The function MAX requires at least 2 arguments. There are too few arguments for the function MAX. Reenter the corrected program or enter "QUIT;" to exit procedure. ERROR: File WORK.FCMPDS1_3.DATA does not exist. WARNING: The data set WORK.FCMPDS1_3 may be incomplete. When this step was stopped there were 0 observations and 2 variables. ERROR: Variable LHS_Dropped is not on file WORK.FCMPDS1_3. WARNING: The data set WORK.FCMPDS1OUT_3 may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.FCMPDS1IN_3 was not replaced because this step was stopped. WARNING: Data set WORK.FCMPDS1_3 was not replaced because this step was stopped. ERROR: The variable NAME in the DROP, KEEP, or RENAME list has never been referenced. ERROR: Invalid DROP, KEEP, or RENAME option on file WORK.FCMPDS1_3. WARNING: The data set WORK.FCMPDS1_3 may be incomplete. When this step was stopped there were 0 observations and 11 variables. WARNING: Data set WORK.FCMPDS1_3 was not replaced because this step was stopped. WARNING: Data set WORK._DCL3 was not replaced because this step was stopped. ERROR: Variable SNIPPET not found. WARNING: Data set WORK.PREPDATA_META was not replaced because this step was stopped. ERROR: Variable QUNAME not found. ERROR: The variable quname in the DROP, KEEP, or RENAME list has never been referenced. ERROR: Invalid DROP, KEEP, or RENAME option on file WORK.PREPDATA_META. WARNING: The data set WORK._SCOPEDCL may be incomplete. When this step was stopped there were 0 observations and 2 variables. WARNING: Data set WORK._SCOPEDCL was not replaced because this step was stopped. WARNING: Data set WORK._SCOPEDCL was not replaced because this step was stopped. 12 The SAS System Sunday, March 31, 2024 10:25:00 PM WARNING: Data set WORK._SCOPEDCL was not replaced because this step was stopped. ERROR: Variable LOCAL not found. ERROR: Variable SNIPPET not found. ERROR: Variable ORDER not found. ERROR: Variable local is not on file WORK._SCOPEDCL. WARNING: The data set WORK._DCL may be incomplete. When this step was stopped there were 0 observations and 4 variables. ERROR: Variable STORE not found. ERROR: Variable SNIPPET not found. WARNING: Data set WORK._DCL was not replaced because this step was stopped. ERROR: Variable SNIPPET not found. ERROR: Variable ORDER not found. ERROR: Variable snippet is not on file WORK._SCOPEDCL. WARNING: The data set WORK._SNIPPETDCL may be incomplete. When this step was stopped there were 0 observations and 2 variables. ERROR: Variable local is not on file WORK._SNIPPETDCL. ERROR: Variable CREATOR is not on file WORK._DCL. WARNING: Physical file does not exist, /opt/sas/v4e059/config/var/tmp/compsrv/default/4fa62989-d396-4df9-914b-2573c213c84c/SAS_work8EA100013656_pdcesx23104/f2c8f9 cc-d166-4a7f-82a2-ecaf8ee7b20e/macropartvars.sas. ERROR: Cannot open %INCLUDE file _DMMAC. (ERROR, ErrorWhileSaving:_EDG0AU8FZS54GXG5THAJ8VRPQ_model) NOTE: run_srv - Execution time: 0 seconds.
You may have accidentally deleted your original post, so you need to repeat the questions(s) here.
You should be able to EDIT and existing post by placing your cursor over the 3 line icon next to the subject line of the post and selecting "Edit Reply" from the drop down list.
Or click on REPLY to respond to an existing post, even one of your own.
The posted log appears to have ALL of the actual code inside of a macro. That means that the log shows reduced details. You can get a more detailed log by submitting this code BEFORE the line where you execute a macro:
Options MPRINT; %dmcas_run_srv; options NOMPRINT;
the NOMPRINT turns of the details.
Then show that log.
One strongly suspects that you may not have written the macro in question so solutions may difficult to implement. There are multiple warnings that your data is not as the program expects. The first is the top with the warnings about different lengths of same named variables.
Of especial concern to my eye is the warning about the EVENT_VALUE and _FMTVAR_ variables. When the data value length is 1 it is quite often a sign that all of the values may have been missing in a data source. However since the things that would complain about such involve two data sets being combined the particular code doing so becomes important in that you could be truncating values. So you want to find the set used as DATA, look at the source and determine why those lengths have changed and if indeed EVENT_VALUE and _FMTVAR_ has correct or any values.
The second items of concern are the Uninitialized variables. That means you have code that lists the variables in some place but there are no values assigned. That may again point to a problem with a data source.
Your log also shows many places where you have a data set with one observation. I have a gut feeling that that is part of what is leading to the first actual ERROR
ERROR: The function MAX requires at least 2 arguments. There are too few arguments for the function MAX. Reenter the corrected program or enter "QUIT;" to exit procedure.
Where something is expecting to find the maximum of two or more items that were not created properly prior.
That error message is like the cause of the next one as the step caused an error so the expected output data set wasn't created and everything following fails.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Ready to level-up your skills? Choose your own adventure.