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.
The error message is very clear and definitive. No model has been specified.
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?
The log shown does not contain a MODEL statement. So this is not the code you ran that produced the log above.
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.
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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.