1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;2 OPTIONS LOCALE=en_US DFLANG=LOCALE;3 FILENAME _WEBOUT TEMP;4 FILENAME _RTFOUT TEMP ENCODING='UTF-8';5 FILENAME _PDFOUT TEMP ;6 OPTIONS PRINTERPATH=PDF;7 FILENAME _GSFNAME TEMP;8 FILENAME _DATAOUT TEMP;9 %LET SYSCC=0;10 %LET _CLIENTAPP=SAS Studio;11 %LET _CLIENTAPPVERSION=3.1;12 %LET _SASPROGRAMFILE = %BQUOTE(/folders/myshortcuts/batch5/homework/Tmani/Program3/5.2.2exploring daily and weekly12 ! prog.sas);13 DATA _NULL_;14 CALL SYMPUT("GRAPHINIT","");15 CALL SYMPUT("GRAPHTERM","");16 RC=TSLVL('GEOCODE');17 _ERROR_=0;18 IF (RC^=' ' ) THEN DO;19 CALL SYMPUT("GRAPHINIT","GOPTIONS RESET=ALL GSFNAME=_GSFNAME;");20 CALL SYMPUT("GRAPHTERM","GOPTIONS NOACCESSIBLE;");21 END;22 RUN;23 %LET _DATAOUT_MIME_TYPE=;24 %LET _DATAOUT_NAME=;25 %LET _DATAOUT_TABLE=;26 %LET _DATAOUT_URL=;27 %SYMDEL _DATAOUT_MIME_TYPE _DATAOUT_NAME _DATAOUT_URL _DATAOUT_TABLE;28 %LET _SASWS_ = %BQUOTE(/folders/myfolders);29 %LET _SASWSTEMP_=%BQUOTE(/folders/myfolders/.images/bd2f2f06-a9d2-4d0c-9706-4fcd854d795b);30 ODS LISTING CLOSE;31 ODS LISTING GPATH="&_SASWSTEMP_";32 ODS AUTONAVIGATE OFF;33 ODS GRAPHICS ON;34 ODS HTML5 (ID=WEB) DEVICE=PNG GPATH="&_SASWSTEMP_" ENCODING=utf8 FILE=_WEBOUT (TITLE='Results: 5.2.2exploring daily and34 ! weekly prog.sas') STYLE=Htmlblue OPTIONS(BITMAP_MODE='INLINE' SVG_MODE='INLINE'34 ! CSS_PREFIX='#ods_bd2f2f06-a9d2-4d0c-9706-4fcd854d795b' BODY_ID='div_bd2f2f06-a9d2-4d0c-9706-4fcd854d795b' );35 ODS RTF (ID=WEB) STYLE=Rtf FILE=_RTFOUT36 ;ODS PDF (ID=WEB) STYLE=Pearl FILE=_PDFOUT37 ;&GRAPHINIT;38 OPTIONS FIRSTOBS=1;39 OPTIONS OBS=MAX;40 OPTIONS DTRESET DATE NUMBER NOTES;41 OPTIONS NOTES STIMER SOURCE NOSYNTAXCHECK;42 ;4344 options mcompilenote=all;45 %macro daily;46 proc print data=orion3.order_fact;47 where order_date="&sysdate9"d;48 var product_id total_retail_price;49 title"Daily sales: "&sysdate9";50 run;51 %mend daily;525354 %macro weekly;55 proc means data=orion3.order_fact n sum mean;56 where order_date between "&sysdate9"d - 6 and56 ! "&sysdate9"_4956 ! d;NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white spacebetween a quoted string and the succeeding identifier is recommended.57 var quantity total_retail_price;58 title "Weekly sales: &sysdate9";59 run;60 %mend weekly;61 ;62 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;63 ODS HTML CLOSE;64 &GRAPHTERM;65 ;*';*";*/;QUIT;RUN;66 QUIT;RUN;67 ODS HTML5 (ID=WEB) CLOSE;68 ODS RTF (ID=WEB) CLOSE;69 ODS PDF (ID=WEB) CLOSE;70 FILENAME _GSFNAME;71 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;72 ;