Sorry for posting my question again but the previous post does not let me to reply to the comments: Here is my code and error that I get: Thanks for your help. Please see the entire code and log below: Code: %LET DAYS= %EVAL( %SYSFUNC(INTNX(QTR,'01JAN2022'D, (&LOOP-1), E))-%SYSFUNC(INTNX(QTR,'01JAN2022'D, (&LOOP-1), B)) + 1); %LET QUARTER_DAY_START = %SYSFUNC(DEQUOTE(" '%SYSFUNC(INTNX(MONTH, '01JAN2022'D, (&LOOP-1)*3, B), DATE11.)' ")); %LET QUARTER_DAY_END = %SYSFUNC(DEQUOTE(" '%SYSFUNC(INTNX(MONTH, '01JAN2022'D, ((&LOOP-1)*3)+ 2, E), DATE11.)' ")); %LET QUARTER_START_DATE = %SYSFUNC(INTNX(QTR,'01JAN2022'D,0,B)); %LET QUARTER_END_DATE = %SYSFUNC(INTNX(QTR,'01JAN2022'D,0,E)); %PUT &=DAYS; %PUT &=QUARTER_DAY_START; %PUT &=QUARTER_DAY_END; DATA MY_NEW_TABLE; SET WORK.MY_OLD_TABLE; date = intnx('qtr','01jan2022'd,qtr-1,'b') to intnx('qtr','01jan2022'd,qtr-1,'e'); RUN; Log: 1 The SAS System 06:13 Tuesday, December 13, 2022 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program 3'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 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 MPRINT(HTML5ACCESSIBLEGRAPHSUPPORTED): ACCESSIBLE_GRAPH 21 ENCODING='utf-8' 22 STYLE=HtmlBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation 26 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 %LET DAYS= %EVAL( %SYSFUNC(INTNX(QTR,'01JAN2022'D, (&LOOP-1), E))-%SYSFUNC(INTNX(QTR,'01JAN2022'D, (&LOOP-1), B)) + 1) 28 ! ; 29 %LET QUARTER_DAY_START = %SYSFUNC(DEQUOTE(" '%SYSFUNC(INTNX(MONTH, '01JAN2022'D, (&LOOP-1)*3, B), DATE11.)' ")); 30 %LET QUARTER_DAY_END = %SYSFUNC(DEQUOTE(" '%SYSFUNC(INTNX(MONTH, '01JAN2022'D, ((&LOOP-1)*3)+ 2, E), DATE11.)' ")); 31 %LET QUARTER_START_DATE = %SYSFUNC(INTNX(QTR,'01JAN2022'D,0,B)); 32 %LET QUARTER_END_DATE = %SYSFUNC(INTNX(QTR,'01JAN2022'D,0,E)); 33 %PUT &=DAYS; DAYS=90 34 %PUT &=QUARTER_DAY_START; QUARTER_DAY_START='01-JAN-2022' 35 %PUT &=QUARTER_DAY_END; QUARTER_DAY_END='31-MAR-2022' 36 37 37 ! DATA MY_NEW_TABLE; 38 SET WORK.MY_OLD_TABLE ; 39 date = intnx('qtr','01jan2022'd,qtr-1,'b') to intnx('qtr','01jan2022'd,qtr-1,'e'); __ 22 202 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. ERROR 202-322: The option or parameter is not recognized and will be ignored. 40 RUN; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.MY_NEW_TABLE may be incomplete. When this step was stopped there were 0 observations and 5 variables. 2 The SAS System 06:13 Tuesday, December 13, 2022 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 41 42 %LET _CLIENTTASKLABEL=; 43 %LET _CLIENTPROCESSFLOWNAME=; 44 %LET _CLIENTPROJECTPATH=; 45 %LET _CLIENTPROJECTPATHHOST=; 46 %LET _CLIENTPROJECTNAME=; 47 %LET _SASPROGRAMFILE=; 48 %LET _SASPROGRAMFILEHOST=; 49 50 ;*';*";*/;quit;run; 51 ODS _ALL_ CLOSE; 52 53 54 QUIT; RUN; 55
... View more