Re: Please Help: Score Node Run Time Error in Enterprise Miner

ECUHart · Posted 02-18-2020 02:20 PM

Hi,

I need help. I'm working on an assignment for my Data Mining course and my score node won't function properly. It keeps pulling a run time error:

treeconversion=0

14286 %let syscc=0;

14287 filename _wipchk catalog "EMWS1.CNTRL.test.source";

14288 data _null_;

14289 file _wipchk;

14290 put '/* Test */';

14291 run;

NOTE: The file _WIPCHK is:

Catalog Name=EMWS1.CNTRL.TEST.SOURCE,

Catalog Page Size=4096,

Number of Catalog Pages=5,

Created=Mon, Feb 17, 2020 09:03:39 AM,

Last Modified=Tue, Feb 18, 2020 01:45:51 PM,

Filename=U:\House Prices\House Prices\Workspaces\EMWS1\cntrl.sas7bcat,

Release Created=9.0401M1,Host Created=X64_7PRO

NOTE: 1 record was written to the file _WIPCHK.

The minimum record length was 10.

The maximum record length was 10.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

14292 data _null_;

14293 rc = fdelete('_wipchk');

14294 run;

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.00 seconds

14295 filename _wipchk;

NOTE: Fileref _WIPCHK has been deassigned.

14296 filename _wipxml 'C:\Users\hartb10\AppData\Local\Temp\45\SAS Temporary Files\_TD25404_VCLCTX-XA-03_\Prc2\DiagramOpenSessionResponse.xml' encoding="UTF-8" NOBOM;

34 The SAS System 13:23 Tuesday, February 18, 202

0

WARNING: End of file.

Can anyone help?

Thanks,

ECUHart · Posted 02-18-2020 02:21 PM

Here's an attachment with a screen shot from enterprise miner.

RobWobDobBlobb · Posted 02-19-2020 07:55 AM

Hi ECUHart,

I didn't find any ERROR message in the log that you provided.

What you're showing are probably the log entries for the top your node (DATA step).

If you search the log of the Score node for "ERROR", what does it show?

ECUHart · Posted 02-19-2020 09:29 AM

Hi RobWobDobBlobb,

Thanks for replying. Here's what see from the Score Node Results Error:

ERROR 48-59: The format $BEST was not found or could not be loaded.

ERROR 305-185: Label has already been used.

WARNING: The data set EMWS1.SCORE_SCORE may be incomplete. When this step was stopped there were 0 observations and 89 variables.
*------------------------------------------------------------*
*
* ERROR: Run time error was encountered. The system error returned was -S-.
* Please report unresolved problems to Technical Support.

RobWobDobBlobb · Posted 02-19-2020 10:28 AM

Hi ECUHart,

So a couple of things:

- If you re-run the Score node, does it produce the same error?

ERROR 48-59: The format $BEST was not found or could not be loaded.

ERROR 305-185: Label has already been used.

- In order to find out what is wrong need to check the lines 48-59 in your Log, this is where the error is produced.

- The second error is a bit odd as the line numbers are given in reverse, but this is not really a problem as it is most likely a dependency of the first error.

If you want help with debugging the error I'll need the following informations:

- The lines immediately leading up to the ERROR message in the Log

- The Log lines 48 - 59

- The parameters you set in the Score node in SAS EM

- The model nodes / nodes that you run prior to the scoring

RobWobDobBlobb · Posted 02-19-2020 10:58 AM

Hi RobWobDobBlobb,

I appreciate your time in helping me with this. Yes, the same error(s) appear today.

Here's the Run from Yesterday, Immediately after I'll post today's results. I've attached via Word a picture of the model with the nodes that I ran before the score node.

Date: February 18, 2020
Time: 15:25:09
Site: 70211749
Platform: X64_7PRO
Maintenance Release: 9.04.01M1P120413
EM Version: 13.1
*
*------------------------------------------------------------*
* Training Log
Date: February 18, 2020
Time: 15:25:07
*------------------------------------------------------------*
10733 proc freq data=EMWS1.Score_VariableSet noprint;
10734 table ROLE*LEVEL/out=WORK.ScoreMETA;
10735 run;

NOTE: There were 2 observations read from the data set EMWS1.SCORE_VARIABLESET.
NOTE: The data set WORK.SCOREMETA has 2 observations and 4 variables.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

10736 proc print data=WORK.ScoreMETA label noobs;
10737 var ROLE LEVEL COUNT;
10738 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))";
10739 title9 ' ';
10740 title10 "%sysfunc(sasmsg(sashelp.dmine, rpt_varSummary_title , NOQUOTE))";
10741 run;

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

10742 title10;

10743 %let groupid =;
10744 %let endGroupid =;
10745 %let prescoreid =;
10746 data _null_;
10747 set EMWS1.Reg_EMINFO;
10748 where key in('PRESCORECODE','ENDGROUP', 'GROUPINFO', 'BOOSTINFO', 'BAGINFO', 'TARGETINFO', 'INDEXINFO');
10749 select(key);
10750 when('PRESCORECODE') call symput('prescoreId', DATA);
10751 when('ENDGROUP') call symput('endGroupId', DATA);
10752 otherwise call symput('groupId', DATA);
10753 end;
10754 run;

NOTE: There were 0 observations read from the data set EMWS1.REG_EMINFO.
WHERE key in ('BAGINFO', 'BOOSTINFO', 'ENDGROUP', 'GROUPINFO', 'INDEXINFO', 'PRESCORECODE', 'TARGETINFO');
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _INIT >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
NOTE: There were 1 observations read from the data set EMWS1.REG_EMINFO.
WHERE (TARGET='SalePrice') and (KEY='MODEL');
NOTE: The data set WORK.EMINFO41_29T0G has 1 observations and 3 variables.
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL NUMELEMENTS >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _term >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _INIT >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
NOTE: There were 1 observations read from the data set EMWS1.REG_EMINFO.
WHERE (TARGET='SalePrice') and (KEY='DECMETA');
NOTE: The data set WORK.EMINFO41YA8YGD has 1 observations and 3 variables.
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _term >>
NOTE: This SAS session is using a registry in WORK. All changes will be lost at the end of this session.
11574 _dm12 = put( GarageCars , BEST12. );
-------
48
13309 _dm12 = put( GarageCars , BEST12. );
-------
48
14289 REGDR1:
------
305
15044 _dm12 = put( GarageCars , BEST12. );
-------
48
16024 REGDR1:
------
305
16779 _dm12 = put( GarageCars , BEST12. );
-------
48
17759 REGDR1:
------
305
18514 _dm12 = put( GarageCars , BEST12. );
-------
48
19494 REGDR1:
------
305
20249 _dm12 = put( GarageCars , BEST12. );
-------
48
21229 REGDR1:
------
305
21984 _dm12 = put( GarageCars , BEST12. );
-------
48
22964 REGDR1:
------
305
23719 _dm12 = put( GarageCars , BEST12. );
-------
48
24699 REGDR1:
------
305
25454 _dm12 = put( GarageCars , BEST12. );
-------
48
26434 REGDR1:
------
305
27189 _dm12 = put( GarageCars , BEST12. );
-------
48
28169 REGDR1:
------
305
28924 _dm12 = put( GarageCars , BEST12. );
-------
48
29904 REGDR1:
------
305
30659 _dm12 = put( GarageCars , BEST12. );
-------
48
31639 REGDR1:
------
305
ERROR 48-59: The format $BEST was not found or could not be loaded.

ERROR 305-185: Label has already been used.

WARNING: The data set EMWS1.SCORE_SCORE may be incomplete. When this step was stopped there were 0 observations and 89 variables.
*------------------------------------------------------------*
*
* ERROR: Run time error was encountered. The system error returned was -S-.
* Please report unresolved problems to Technical Support.
*
*------------------------------------------------------------*

Date: February 19, 2020
Time: 10:50:46
Site: 70211749
Platform: X64_7PRO
Maintenance Release: 9.04.01M1P120413
EM Version: 13.1
*
*------------------------------------------------------------*
* Training Log
Date: February 19, 2020
Time: 10:50:41
*------------------------------------------------------------*
10733 proc freq data=EMWS1.Score_VariableSet noprint;
10734 table ROLE*LEVEL/out=WORK.ScoreMETA;
10735 run;

NOTE: There were 2 observations read from the data set EMWS1.SCORE_VARIABLESET.
NOTE: The data set WORK.SCOREMETA has 2 observations and 4 variables.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds

10736 proc print data=WORK.ScoreMETA label noobs;
10737 var ROLE LEVEL COUNT;
10738 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))";
10739 title9 ' ';
10740 title10 "%sysfunc(sasmsg(sashelp.dmine, rpt_varSummary_title , NOQUOTE))";
10741 run;

NOTE: There were 2 observations read from the data set WORK.SCOREMETA.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds

10742 title10;

10743 %let groupid =;
10744 %let endGroupid =;
10745 %let prescoreid =;
10746 data _null_;
10747 set EMWS1.Reg_EMINFO;
10748 where key in('PRESCORECODE','ENDGROUP', 'GROUPINFO', 'BOOSTINFO', 'BAGINFO', 'TARGETINFO', 'INDEXINFO');
10749 select(key);
10750 when('PRESCORECODE') call symput('prescoreId', DATA);
10751 when('ENDGROUP') call symput('endGroupId', DATA);
10752 otherwise call symput('groupId', DATA);
10753 end;
10754 run;

NOTE: There were 0 observations read from the data set EMWS1.REG_EMINFO.
WHERE key in ('BAGINFO', 'BOOSTINFO', 'ENDGROUP', 'GROUPINFO', 'INDEXINFO', 'PRESCORECODE', 'TARGETINFO');
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _INIT >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
NOTE: There were 1 observations read from the data set EMWS1.REG_EMINFO.
WHERE (TARGET='SalePrice') and (KEY='MODEL');
NOTE: The data set WORK.EMINFO41M_J3VY has 1 observations and 3 variables.
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL NUMELEMENTS >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _term >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _INIT >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL setMetaData >>
NOTE: There were 1 observations read from the data set EMWS1.REG_EMINFO.
WHERE (TARGET='SalePrice') and (KEY='DECMETA');
NOTE: The data set WORK.EMINFO41Y64G9W has 1 observations and 3 variables.
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL next >>
Executing SASHELP.EMCORE.EMINFOITERATOR.SCL _term >>
NOTE: This SAS session is using a registry in WORK. All changes will be lost at the end of this session.
11588 _dm12 = put( GarageCars , BEST12. );
-------
48
13323 _dm12 = put( GarageCars , BEST12. );
-------
48
14303 REGDR1:
------
305
15058 _dm12 = put( GarageCars , BEST12. );
-------
48
16038 REGDR1:
------
305
16793 _dm12 = put( GarageCars , BEST12. );
-------
48
17773 REGDR1:
------
305
18528 _dm12 = put( GarageCars , BEST12. );
-------
48
19508 REGDR1:
------
305
20263 _dm12 = put( GarageCars , BEST12. );
-------
48
21243 REGDR1:
------
305
21998 _dm12 = put( GarageCars , BEST12. );
-------
48
22978 REGDR1:
------
305
23733 _dm12 = put( GarageCars , BEST12. );
-------
48
24713 REGDR1:
------
305
25468 _dm12 = put( GarageCars , BEST12. );
-------
48
26448 REGDR1:
------
305
27203 _dm12 = put( GarageCars , BEST12. );
-------
48
28183 REGDR1:
------
305
28938 _dm12 = put( GarageCars , BEST12. );
-------
48
29918 REGDR1:
------
305
30673 _dm12 = put( GarageCars , BEST12. );
-------
48
31653 REGDR1:
------
305
32408 _dm12 = put( GarageCars , BEST12. );
-------
48
33388 REGDR1:
------
305
ERROR 48-59: The format $BEST was not found or could not be loaded.

ERROR 305-185: Label has already been used.

WARNING: The data set EMWS1.SCORE_SCORE may be incomplete. When this step was stopped there were 0 observations and 89 variables.
*------------------------------------------------------------*
*
* ERROR: Run time error was encountered. The system error returned was -S-.
* Please report unresolved problems to Technical Support.
*
*------------------------------------------------------------*

Please Help: Score Node Run Time Error in Enterprise Miner