SAS EG RFM Error

shilpas — Sun, 07 Jun 2020 09:09:10 GMT

Hi Everyone,

First timer here.

I've been using SAS 7.15 on my PC for a year and not am trying to migrate all my codes onto a VM having SAS EG 8.2.

The RFM macro doesn't work either via Tasks or the code.

I did try adding a ODS path ODS PATH(PREPEND) WORK.TEMPLAT(UPDATE) before the macro.

I am also getting a Graphics error - assuming the RFM is not running because of that.

ERROR: The SVG driver can not find any fonts. No output will be created.

So i tried a lockdown statement but again got an error.

WARNING: The LOCKDOWN statement was not executed. Set the LOCKDOWN system option and add the LOCKDOWN statement to an AUTOEXEC file or to the INITSTMT statement.

Also tried the SYMBOLGEN option to see what is going on - but i couldnt understand what the issue was.Can someone pls help?

Attaching the entire log below;

1 The SAS System 01:45 Sunday, June 7, 2020

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Step2_RFM_Binning_Tenured_Cust.sas';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='E:\RFM_Binning_Tenured_Cust.sas';
9 %LET _SASPROGRAMFILEHOST='RETAIL-ANALYTIC';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGHTML TEMP;
18 ODS HTML5(ID=EGHTML) FILE=EGHTML
19 OPTIONS(BITMAP_MODE='INLINE')
20 %HTML5AccessibleGraphSupported
SYMBOLGEN: Macro variable SYSVLONG resolves to 9.04.01M6P110718
SYMBOLGEN: Macro variable CURMAJ resolves to 9
SYMBOLGEN: Macro variable FMAJOR resolves to 9
SYMBOLGEN: Macro variable FMINOR resolves to 4
SYMBOLGEN: Macro variable FMAINT resolves to 4
SYMBOLGEN: Macro variable SYSVLONG resolves to 9.04.01M6P110718
SYMBOLGEN: Macro variable SYSVLONG resolves to 9.04.01M6P110718
SYMBOLGEN: Macro variable MAJOR resolves to 9
SYMBOLGEN: Macro variable CURMAJ resolves to 9
SYMBOLGEN: Macro variable MINOR resolves to 4
SYMBOLGEN: Macro variable CURMIN resolves to 04
SYMBOLGEN: Macro variable MAINT resolves to 4
SYMBOLGEN: Macro variable CURMNT resolves to 6
SYMBOLGEN: Macro variable MAINT resolves to 4
MPRINT(HTML5ACCESSIBLEGRAPHSUPPORTED): ACCESSIBLE_GRAPH
21 ENCODING='utf-8'
22 STYLE=HTMLBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
SYMBOLGEN: Macro variable SASWORKLOCATION resolves to
"C:\Users\AppData\Roaming\SAS\EnterpriseGuide\EGTEMP\SEG-12608-8767202c\contents\SAS Temporary
Files\_TD4408_RETAIL-ANALYTIC_\Prc2/"
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
ERROR: The SVG driver can not find any fonts. No output will be created.
ERROR: The SVG driver can not find any fonts. No output will be created.
WARNING: Apparent invocation of macro AARFM_EXEC not resolved.
MPRINT(AARFM): %aaRFM_exec;
27
28 %AARFM;
NOTE: Line generated by the invoked macro "AARFM".
28 %aaRFM_exec;
_
180

ERROR 180-322: Statement is not valid or it is used out of proper order.

2 The SAS System 01:45 Sunday, June 7, 2020

WARNING: Apparent invocation of macro EM_RFM_CONTROL not resolved.
29 %EM_RFM_CONTROL
_
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

30 (
31 MODE = C,
32 INDATA = WORK.A3,
33 CUSTOMERID = ID,
34 N_R_GRP = 5,
35 N_F_GRP = 5,
36 N_M_GRP = 5,
37 BINMETHOD = N,
38 PURCHASEDATE = ,
39 PURCHASEAMT = ,
40 SETMISS = Y,
41 SUMMARYFUNC = SUM,
42 MOSTRECENTDATE = LAST_TXN_DATE,
43 NPURCHASE = TXNS,
44 TOTPURCHASEAMT = SALES,
45 MONETIZATIONMAP = Y,
46 BINCHART = Y,
47 BINTABLE = Y,
48 OUTDATA = WORK.RFM_TABLE,
49 RECENCY_SCORE = RECENCY_SCORE,
50 FREQUENCY_SCORE = FREQUENCY_SCORE,
51 MONETARY_SCORE = MONETARY_SCORE,
52 RFM_SCORE = RFM_SCORE
53 );

54
55
56 %LET _CLIENTTASKLABEL=;
57 %LET _CLIENTPROCESSFLOWNAME=;
58 %LET _CLIENTPROJECTPATH=;
59 %LET _CLIENTPROJECTPATHHOST=;
60 %LET _CLIENTPROJECTNAME=;
61 %LET _SASPROGRAMFILE=;
62 %LET _SASPROGRAMFILEHOST=;
63
64 ;*';*";*/;quit;run;
65 ODS _ALL_ CLOSE;
66
67
68 QUIT; RUN;
69

Re: SAS EG RFM Error

Kurt_Bremser — Sun, 07 Jun 2020 11:19:15 GMT

You are somehow missing the necessary macro definitions. Either there was a problem during installation of the SAS system (not EG), or you have an incomplete setting of the SASAUTOS system option

Re: SAS EG RFM Error

shilpas — Sun, 07 Jun 2020 11:34:26 GMT

Hi @Kurt_Bremser,
Thank you for the reply - i will check in with the installation team.
Meanwhile- will check the libraries/macros made available for SASAUTOS..

topic SAS EG RFM Error in SAS Enterprise Guide

SAS EG RFM Error

Re: SAS EG RFM Error

Re: SAS EG RFM Error