Hi all,
I am using an existing macro code from another program but I am getting error. I am not sure what is wrong with the macro. Could you please look at the macro and suggest how to correct it?
/*Create date macros*/
%let REP_DATE_START = %sysfunc(intnx(month,"&REP_DATE_START_END."d,0,begin));
%let PQ_REP_DATE_START = %sysfunc(intnx(month,"&REP_DATE_START_END."d,-3,begin));
%let yyyymm = %sysfunc(intnx(month,"&REP_DATE_START_END."d,0,begin),yymmn6.);
%let yyyymm_Camel = %sysfunc(intnx(month,"&REP_DATE_START_END."d,-1,begin),yymmn6.);
Error message:
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Set up';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
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
21 ENCODING='utf-8'
22 STYLE=HTMLBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
WARNING: Apparent symbolic reference REP_DATE_START_END not resolved.
WARNING: Apparent symbolic reference REP_DATE_START_END not resolved.
ERROR: Argument 2 to function INTNX referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number.
ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC
or %QSYSFUNC function reference is terminated.
27
28 /*Create date macros*/
29 %let REP_DATE_START = %sysfunc(intnx(month,"&REP_DATE_START_END."d,0,begin));
30 %let PQ_REP_DATE_START = %sysfunc(intnx(month,"&REP_DATE_START_END."d,-3,begin));
WARNING: Apparent symbolic reference REP_DATE_START_END not resolved.
WARNING: Apparent symbolic reference REP_DATE_START_END not resolved.
ERROR: Argument 2 to function INTNX referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number.
ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC
or %QSYSFUNC function reference is terminated.
31 %let yyyymm = %sysfunc(intnx(month,"&REP_DATE_START_END."d,0,begin),yymmn6.);
WARNING: Apparent symbolic reference REP_DATE_START_END not resolved.
WARNING: Apparent symbolic reference REP_DATE_START_END not resolved.
ERROR: Argument 2 to function INTNX referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number.
ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC
or %QSYSFUNC function reference is terminated.
32 %let yyyymm_Camel = %sysfunc(intnx(month,"&REP_DATE_START_END."d,-1,begin),yymmn6.);
WARNING: Apparent symbolic reference REP_DATE_START_END not resolved.
WARNING: Apparent symbolic reference REP_DATE_START_END not resolved.
ERROR: Argument 2 to function INTNX referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number.
ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC
or %QSYSFUNC function reference is terminated.
33
34 %LET _CLIENTTASKLABEL=;
35 %LET _CLIENTPROCESSFLOWNAME=;
36 %LET _CLIENTPROJECTPATH=;
37 %LET _CLIENTPROJECTPATHHOST=;
2 The SAS System 15:08 Tuesday, February 20, 2024
38 %LET _CLIENTPROJECTNAME=;
39 %LET _SASPROGRAMFILE=;
40 %LET _SASPROGRAMFILEHOST=;
41
42 ;*';*";*/;quit;run;
43 ODS _ALL_ CLOSE;
44
45
46 QUIT; RUN;
