SAS node error

Jonison — Mon, 15 Jul 2019 09:39:38 GMT

Hello, All, I created a PLS SAS node, and it is passed and showed all of results when click 'Run Code'

But when clicking 'Run Node' , it shows ERROR: model is not specified.

The whole log message is here:

*------------------------------------------------------------*
User: jz474385
Date: 15 July 2019
Time: 10:19:08 o'clock
Site: 70178890
Platform: Linux
Maintenance Release: 9.04.01M3P062415
EM Version: 14.1
*
*------------------------------------------------------------*
* Training Log
Date: 15 July 2019
Time: 10:19:04 o'clock
*------------------------------------------------------------*
14727 proc freq data=EMWS2.EMCODE_VariableSet noprint;
14728 table ROLE*LEVEL/out=WORK.EMCODEMETA;
14729 run;

NOTE: There were 125 observations read from the data set EMWS2.EMCODE_VARIABLESET.
NOTE: The data set WORK.EMCODEMETA has 7 observations and 4 variables.
NOTE: Compressing data set WORK.EMCODEMETA increased size by 100.00 percent.
Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

14730 proc print data=WORK.EMCODEMETA label noobs;
14731 var ROLE LEVEL COUNT;
14732 label ROLE = "%sysfunc(sasmsg(sashelp.dmine, meta_role_vlabel, NOQUOTE))" LEVEL = "%sysfunc(sasmsg(sashelp.dmine, meta_level_vlabel, NOQUOTE))" COUNT = "%sysfunc(sasmsg(sashelp.dmine, rpt_count_vlabel, NOQUOTE))";
14733 title9 ' ';
14734 title10 "%sysfunc(sasmsg(sashelp.dmine, rpt_varSummary_title , NOQUOTE))";
14735 run;

NOTE: There were 7 observations read from the data set WORK.EMCODEMETA.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.02 seconds

14736 title10;

14737 %let EMNORLEN = %DMNORLEN;
EMWS2.Trans2_TRAIN EMWS2.Trans2_TRAIN
EMWS2.Trans2_TRAIN EMWS2.Trans2_TRAIN EMWS2 Trans2_TRAIN
EMWS2.Trans2_TRAIN EMWS2.Trans2_TRAIN
EMWS2.Trans2_TRAIN EMWS2.Trans2_TRAIN EMWS2 Trans2_TRAIN
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _INIT >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _term >>
>>>>>>>>>>>>>> TARGET( USE='Y'
REPORT='Y'
NAME='STD_FP_1_5'
ROLE='TARGET'
LEVEL='INTERVAL'
ORDER=''
CREATOR='Trans'
FORMATTYPE=''
FAMILY=''
LOWERLIMIT=.
UPPERLIMIT=.
DISTRIBUTION=''
COMMENT='(FP_1_5 - 130.80365553) / 6.6600393485'
PRICE=.
TYPE='N'
LABEL='Transformed: FP_1_5'
FORMAT=''
INFORMAT=''
INDEX='N'
INDEXTYPE='NONE'
LENGTH=8
)[11367]
PERFORMANCE DETAILS
WORK.EM_DMDB WORK.EM_DMDB
WORK.EM_DMDB WORK.EM_DMDB WORK EM_DMDB
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _INIT >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _term >>
>>>>>>>>>>>>>> TARGET( USE='Y'
REPORT='Y'
NAME='STD_FP_3_4'
ROLE='TARGET'
LEVEL='INTERVAL'
ORDER=''
CREATOR='Trans'
FORMATTYPE=''
FAMILY=''
LOWERLIMIT=.
UPPERLIMIT=.
DISTRIBUTION=''
COMMENT='(FP_3_4 - 73.822931105) / 4.4211879754'
PRICE=.
TYPE='N'
LABEL='Transformed: FP_3_4'
FORMAT=''
INFORMAT=''
INDEX='N'
INDEXTYPE='NONE'
LENGTH=8
)[11365]
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _INIT >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _term >>
>>>>>>>>>>>>>> TARGET( USE='Y'
REPORT='Y'
NAME='STD_FP_SX_FPM_Ratio'
ROLE='TARGET'
LEVEL='INTERVAL'
ORDER=''
CREATOR='Trans'
FORMATTYPE=''
FAMILY=''
LOWERLIMIT=.
UPPERLIMIT=.
DISTRIBUTION=''
COMMENT='(FP_SX_FPM_Ratio - 11.745701285) / 0.2780835936'
PRICE=.
TYPE='N'
LABEL='Transformed: FP_SX_FPM_Ratio'
FORMAT=''
INFORMAT=''
INDEX='N'
INDEXTYPE='NONE'
LENGTH=8
)[11367]
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _INIT >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _term >>
>>>>>>>>>>>>>> TARGET( USE='Y'
REPORT='Y'
NAME='STD_SX_1_5'
ROLE='TARGET'
LEVEL='INTERVAL'
ORDER=''
CREATOR='Trans'
FORMATTYPE=''
FAMILY=''
LOWERLIMIT=.
UPPERLIMIT=.
DISTRIBUTION=''
COMMENT='(SX_1_5 - 11.138646941) / 0.554245063'
PRICE=.
TYPE='N'
LABEL='Transformed: SX_1_5'
FORMAT=''
INFORMAT=''
INDEX='N'
INDEXTYPE='NONE'
LENGTH=8
)[11365]
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _INIT >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _term >>
>>>>>>>>>>>>>> TARGET( USE='Y'
REPORT='Y'
NAME='STD_SX_3_4'
ROLE='TARGET'
LEVEL='INTERVAL'
ORDER=''
CREATOR='Trans'
FORMATTYPE=''
FAMILY=''
LOWERLIMIT=.
UPPERLIMIT=.
DISTRIBUTION=''
COMMENT='(SX_3_4 - 6.1192693316) / 0.3689762387'
PRICE=.
TYPE='N'
LABEL='Transformed: SX_3_4'
FORMAT=''
INFORMAT=''
INDEX='N'
INDEXTYPE='NONE'
LENGTH=8
)[11367]
"No decisions defined for target "STD_FP_1_5"."
14930 proc print data = EMWS2.EMCODE_STD_FP_1_5_DM noobs label;
14931 var _type_ variable label;
14932 where _type_ ^in('MATRIX', 'DECISION', 'TRAINPRIOR', 'DATAPRIOR', 'DECPRIOR');
14933 label _TYPE_ = "%sysfunc(sasmsg(sashelp.dmine, rpt_type_vlabel, NOQUOTE))" VARIABLE = "%sysfunc(sasmsg(sashelp.dmine, rpt_variable_vlabel, NOQUOTE))" LABEL = "%sysfunc(sasmsg(sashelp.dmine, meta_label_vlabel, NOQUOTE))";
14934 title9 ' ';
14935 title10 "%sysfunc(sasmsg(sashelp.dmine, rpt_predDecVars_title , NOQUOTE))";
14936 run;

NOTE: There were 3 observations read from the data set EMWS2.EMCODE_STD_FP_1_5_DM.
WHERE _type_ not in ('DATAPRIOR', 'DECISION', 'DECPRIOR', 'MATRIX', 'TRAINPRIOR');
NOTE: The PROCEDURE PRINT printed page 2.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

14937 title10;

"No decisions defined for target "STD_FP_3_4"."
14938 proc print data = EMWS2.EMCODE_STD_FP_3_4_DM noobs label;
14939 var _type_ variable label;
14940 where _type_ ^in('MATRIX', 'DECISION', 'TRAINPRIOR', 'DATAPRIOR', 'DECPRIOR');
14941 label _TYPE_ = "%sysfunc(sasmsg(sashelp.dmine, rpt_type_vlabel, NOQUOTE))" VARIABLE = "%sysfunc(sasmsg(sashelp.dmine, rpt_variable_vlabel, NOQUOTE))" LABEL = "%sysfunc(sasmsg(sashelp.dmine, meta_label_vlabel, NOQUOTE))";
14942 title9 ' ';
14943 title10 "%sysfunc(sasmsg(sashelp.dmine, rpt_predDecVars_title , NOQUOTE))";
14944 run;

NOTE: There were 3 observations read from the data set EMWS2.EMCODE_STD_FP_3_4_DM.
WHERE _type_ not in ('DATAPRIOR', 'DECISION', 'DECPRIOR', 'MATRIX', 'TRAINPRIOR');
NOTE: The PROCEDURE PRINT printed page 3.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

14945 title10;

"No decisions defined for target "STD_FP_SX_FPM_Ratio"."
14946 proc print data = EMWS2.EMCODE_STD_FP_SX_FPM_Ra_DM noobs label;
14947 var _type_ variable label;
14948 where _type_ ^in('MATRIX', 'DECISION', 'TRAINPRIOR', 'DATAPRIOR', 'DECPRIOR');
14949 label _TYPE_ = "%sysfunc(sasmsg(sashelp.dmine, rpt_type_vlabel, NOQUOTE))" VARIABLE = "%sysfunc(sasmsg(sashelp.dmine, rpt_variable_vlabel, NOQUOTE))" LABEL = "%sysfunc(sasmsg(sashelp.dmine, meta_label_vlabel, NOQUOTE))";
14950 title9 ' ';
14951 title10 "%sysfunc(sasmsg(sashelp.dmine, rpt_predDecVars_title , NOQUOTE))";
14952 run;

NOTE: There were 3 observations read from the data set EMWS2.EMCODE_STD_FP_SX_FPM_RA_DM.
WHERE _type_ not in ('DATAPRIOR', 'DECISION', 'DECPRIOR', 'MATRIX', 'TRAINPRIOR');
NOTE: The PROCEDURE PRINT printed page 4.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

14953 title10;

"No decisions defined for target "STD_SX_1_5"."
14954 proc print data = EMWS2.EMCODE_STD_SX_1_5_DM noobs label;
14955 var _type_ variable label;
14956 where _type_ ^in('MATRIX', 'DECISION', 'TRAINPRIOR', 'DATAPRIOR', 'DECPRIOR');
14957 label _TYPE_ = "%sysfunc(sasmsg(sashelp.dmine, rpt_type_vlabel, NOQUOTE))" VARIABLE = "%sysfunc(sasmsg(sashelp.dmine, rpt_variable_vlabel, NOQUOTE))" LABEL = "%sysfunc(sasmsg(sashelp.dmine, meta_label_vlabel, NOQUOTE))";
14958 title9 ' ';
14959 title10 "%sysfunc(sasmsg(sashelp.dmine, rpt_predDecVars_title , NOQUOTE))";
14960 run;

NOTE: There were 3 observations read from the data set EMWS2.EMCODE_STD_SX_1_5_DM.
WHERE _type_ not in ('DATAPRIOR', 'DECISION', 'DECPRIOR', 'MATRIX', 'TRAINPRIOR');
NOTE: The PROCEDURE PRINT printed page 5.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

14961 title10;

"No decisions defined for target "STD_SX_3_4"."
14962 proc print data = EMWS2.EMCODE_STD_SX_3_4_DM noobs label;
14963 var _type_ variable label;
14964 where _type_ ^in('MATRIX', 'DECISION', 'TRAINPRIOR', 'DATAPRIOR', 'DECPRIOR');
14965 label _TYPE_ = "%sysfunc(sasmsg(sashelp.dmine, rpt_type_vlabel, NOQUOTE))" VARIABLE = "%sysfunc(sasmsg(sashelp.dmine, rpt_variable_vlabel, NOQUOTE))" LABEL = "%sysfunc(sasmsg(sashelp.dmine, meta_label_vlabel, NOQUOTE))";
14966 title9 ' ';
14967 title10 "%sysfunc(sasmsg(sashelp.dmine, rpt_predDecVars_title , NOQUOTE))";
14968 run;

NOTE: There were 3 observations read from the data set EMWS2.EMCODE_STD_SX_3_4_DM.
WHERE _type_ not in ('DATAPRIOR', 'DECISION', 'DECPRIOR', 'MATRIX', 'TRAINPRIOR');
NOTE: The PROCEDURE PRINT printed page 6.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

14969 title10;

14970 %let EMEXCEPTIONSTRING=;
14971 %let syscc = 0;
PERFORMANCE DETAILS
15397 *------------------------------------------------------------*;
15398 * EMCODE: Generation of macros and macro variables;
15399 * To see the code generated, set the EM_DEBUG macro variable to SOURCE or _ALL_;
15400 *------------------------------------------------------------*;

15401 %let syscc = 0;
15402 %inc "/home/jz474385//trail/Workspaces/EMWS2/EMCODE/EMTRAINCODE.sas";
NOTE: %INCLUDE (level 1) file /home/jz474385//trail/Workspaces/EMWS2/EMCODE/EMTRAINCODE.sas is file /home/jz474385//trail/Workspaces/EMWS2/EMCODE/EMTRAINCODE.sas.
15403 +
15404 +
15405 +PROC PLS CV=ONE MISSING=AVG METHOD=PLS NOCENTER NOSCALE NOCVSTDIZE NFAC=6 DATA=&EM_IMPORT_DATA details;
NOTE: %INCLUDE (level 1) ending.
15406 *------------------------------------------------------------*;
15407 * Close any missing semi colons;
15408 *------------------------------------------------------------*;
15409 ;
15410 ;
15411 ;
15412 ;
15413 quit;

ERROR: No MODEL specified.
NOTE: View EMWS2.TRANS2_TRAIN.VIEW used (Total process time):
real time 0.14 seconds
cpu time 0.14 seconds

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PLS used (Total process time):
real time 0.14 seconds
cpu time 0.15 seconds

15414 *------------------------------------------------------------*;
15415 * Close any unbalanced quotes;
15416 *------------------------------------------------------------*;
15417 /*; *"; *'; */
15418 ;
15419 run;
15420 quit;
15421 /* Reset EM Options */
15422 options formchar="|----|+|---+=|-/\<>*";
15423 options nocenter ls=256 ps=10000;
15424 goptions reset=all device=GIF NODISPLAY;

*------------------------------------------------------------*
*
* ERROR: Run time error was encountered. The system error returned was 2000.
* Please report unresolved problems to Technical Support.
*
*------------------------------------------------------------*

Would you please suggest on this?

many thanks.

Re: SAS node error

PaigeMiller — Mon, 15 Jul 2019 11:04:00 GMT

The error message is very clear and definitive. No model has been specified.

Re: SAS node error

Jonison — Mon, 15 Jul 2019 11:12:26 GMT

this is my code:

PROC PLS CV=ONE MISSING=AVG METHOD=PLS NOCENTER NOSCALE NOCVSTDIZE NFAC=6 DATA=&EM_IMPORT_DATA details;
MODEL STD_FP_1_5 STD_FP_3_4 STD_SX_1_5 STD_SX_3_4 = BLK1_FPManInd BLK10_DFE_15 BLK10_DFE_MPS ...... (huge amount input variables) BLK9_Sxscore5;

output out=OUTPLS predicted=pred_STD_FP_1_5 pred_STD_FP_3_4 pred_STD_SX_1_5 pred_STD_SX_3_4;
run;

when running the code, it passed and show all of results

when running path, shows ERROR: No MODEL specified.

Would you please advice solution?

Re: SAS node error

PaigeMiller — Mon, 15 Jul 2019 12:00:16 GMT

The log shown does not contain a MODEL statement. So this is not the code you ran that produced the log above.

Re: SAS node error

Jonison — Mon, 15 Jul 2019 12:23:04 GMT

I am pretty sure this is the message from the node.

It seems that PLS PROC cannot handle large number of inputs, when I shorten the variable list, it works.

I think this is the software issue.

Re: SAS node error

Jonison — Mon, 15 Jul 2019 16:09:49 GMT

has been solved, I think put too many variables in MODEL statement makes impossible to execute.

just use %let to define xvars and yvars, and nodes can be executed successfully.

thanks for helping.

topic Re: SAS node error in New SAS User

SAS node error

Re: SAS node error

Re: SAS node error

Re: SAS node error

Re: SAS node error

Re: SAS node error