Not sure if I'm doing the right thing, but getting an error msg, I think this maybe due to Nov end of month being today.... 1 The SAS System 09:12 Wednesday, November 30, 2011 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Code1); 4 %LET _EGTASKLABEL=%NRBQUOTE(Code1); 5 %LET _CLIENTPROJECTNAME=%NRBQUOTE(); 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; NOTE: Some of your options or statements may not be supported with the Activex or Java series of devices. Graph defaults for these drivers may be different from other SAS/GRAPH device drivers. For further information, please contact Technical Support. 9 OPTIONS DEV=ACTIVEX; 10 FILENAME EGHTML TEMP; NOTE: Writing HTML(EGHTML) Body file: EGHTML 11 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' STYLE=EGDefault 11 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared%20Files/BIClientStyles/EGDefault.css") 11 ! ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v91/sasgraph.exe") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation 11 ! ; 12 13 %gaccessible; 14 %put &thismonthstart; 01NOV2011 15 DATA _tNULL_; 16 format mth lstmth $6. dt1 date9. dt2 date9. monthend1 date9.; 17 DT1=intnx('week.6',intnx('month',&ThisMonthStart.,0,'end'),0); _____ 72 NOTE: Line generated by the macro variable "THISMONTHSTART". 17 01NOV2011 _______ 22 18 DT2=intnx('week.6',intnx('month',&ThisMonthStart.,-1,'end'),0); _____ 72 NOTE: Line generated by the macro variable "THISMONTHSTART". 18 01NOV2011 _______ 22 19 MonthEnd1=intnx('month',&ThisMonthStart.,0,'end'); _____ 72 NOTE: Line generated by the macro variable "THISMONTHSTART". 19 01NOV2011 _______ 22 ERROR 72-185: The INTNX function call has too many arguments. ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=. 20 Mth=COMPRESS(year(dt1)*100+month(dt1)); 21 Lstmth=COMPRESS(year(DT2)*100+month(DT2)); 22 output; 23 CALL symput("rpt",mth); 24 CALL symput("prerpt",Lstmth); 25 call symput("ThisMonthEnd",monthend1); 26 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2 The SAS System 09:12 Wednesday, November 30, 2011 17:51 18:51 19:42 20:27 21:30 25:28 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK._TNULL_ may be incomplete. When this step was stopped there were 0 observations and 6 variables. WARNING: Data set WORK._TNULL_ was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 27 28 29 %LET _CLIENTTASKLABEL=; 30 %LET _EGTASKLABEL=; 31 %LET _CLIENTPROJECTNAME=; 32 %LET _SASPROGRAMFILE=; 33 34 ;*';*";*/;quit;run; 35 ODS _ALL_ CLOSE; 36 37 38 QUIT; RUN;
... View more