Macro lesson 5.2.8, I got the following note statement. Please explain

5 views
Skip to first unread message

Thirumagal manivannan

unread,
Oct 23, 2014, 2:22:39 PM10/23/14
to anova...@googlegroups.com
Hi,
Macro lesson 5.2.8, I got the following note statement. Please explain

Code

options mcompilenote=all;
%macro daily;
proc print data=orion3.order_fact;
where order_date="&sysdate9"d;
var product_id total_retail_price;
title"Daily sales: "&sysdate9";
run;
%mend daily;


%macro weekly;
proc means data=orion3.order_fact n sum mean;
where order_date between "&sysdate9"d - 6 and "&sysdate9"d;
var quantity total_retail_price;
title "Weekly sales: &sysdate9";
run;
%mend weekly;

log

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 weekly
12 ! 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 and
34 ! 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=_RTFOUT
36 ;ODS PDF (ID=WEB) STYLE=Pearl FILE=_PDFOUT
37 ;&GRAPHINIT;
38 OPTIONS FIRSTOBS=1;
39 OPTIONS OBS=MAX;
40 OPTIONS DTRESET DATE NUMBER NOTES;
41 OPTIONS NOTES STIMER SOURCE NOSYNTAXCHECK;
42 ;
43
44 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;
52
53
54 %macro weekly;
55 proc means data=orion3.order_fact n sum mean;
56 where order_date between "&sysdate9"d - 6 and
56 ! "&sysdate9"
_
49
56 ! d;
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space
between 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 ;

Anova Groups

unread,
Oct 24, 2014, 10:13:20 AM10/24/14
to anova...@googlegroups.com
In Daily macro, title statement double quotes are mismatching.
Reply all
Reply to author
Forward
0 new messages