Here is the log:
1 The SAS System 14:30 Monday, July 15, 2019
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='TrendPlot071519';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='S:\Alcstudy\ComboDataEntry\Joe\Inflation\Subcategories\MasterDataset and RegressionLogProp1.egp';
6 %LET _CLIENTPROJECTNAME='MasterDataset and RegressionLogProp1.egp';
7 %LET _SASPROGRAMFILE='S:\Alcstudy\ComboDataEntry\Joe\Inflation\Subcategories\TrendPlot071519.sas';
8
9 ODS _ALL_ CLOSE;
10 OPTIONS DEV=ACTIVEX;
11 GOPTIONS XPIXELS=0 YPIXELS=0;
12 FILENAME EGSR TEMP;
13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
14 STYLE=HtmlBlue
15 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
16 NOGTITLE
17 NOGFOOTNOTE
18 GPATH=&sasworklocation
19 ENCODING=UTF8
20 options(rolap="on")
21 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
22
23 GOPTIONS ACCESSIBLE;
24 *Money trend by DS on one frame;
25 %macro Quarter(data,category,out,label,title);
26 proc sql;
27 create table &category._&out. as select
28 mean(I_PreResYr1stT_&category) as Pre_Q1,
29 mean(I_PreResYr2ndT_&category) as Pre_Q2,
30 mean(I_PreResYr3rdT_&category) as Pre_Q3,
31 mean(I_PostResYr1stT_&category) as Pos_Q1,
32 mean(I_PostResYr2ndT_&category) as Pos_Q2,
33 mean(I_PostResYr3rdT_&category) as Pos_Q3
34 from &data
35 where TRICHOT_1YR ne . and Full_Alc_Exp = 1
36 group by TRICHOT_1YR;
37 quit;
38
39 proc transpose data=&category._&out. out=&category._&out.;run;
40
41 data &category._&out. ; set &category._&out. ;
42 rename COL1 =RA COL2 =UR COL3 =RNA; run;
43
44 data &category._&out.;
45 set &category._&out.;
46 Quadrimester = substr(_NAME_,5,2);
47 if substr(_NAME_,1,3)="Pos" then Year="Post Resolution";
48 if substr(_NAME_,1,3)="Pre" then Year="Pre Resolution";
49 drop _NAME_;
50 run;
51
52 ods graphics / reset=all border=off width=700px height=500px;
53 title height=0.2in "&title";
54 proc sgpanel data=&category._&out.;
55 panelby Year/sort=(descformat) headerattrs=(weight=bold);
56 series x=Quadrimester y=RA/
57 markers markerattrs=(symbol=circlefilled size=3pct color=blue) lineattrs=(color=blue thickness=4 pattern=longdash);
2 The SAS System 14:30 Monday, July 15, 2019
58 series x=Quadrimester y=UR/
59 markers markerattrs=(symbol=circlefilled size=3pct color=red) lineattrs=(color=red thickness=4 pattern=ShortDashDot);
60 series x=Quadrimester y=RNA/
61 markers markerattrs=(symbol=circlefilled size=3pct color=green) lineattrs=(color=green thickness=4 pattern=solid);
62
63 rowaxis label="&label" labelattrs=(size=12pt weight=bold) valueattrs=(size=12pt weight=bold);
64 colaxis label=' ' labelattrs=(size=12pt weight=bold) valueattrs=(size=12pt weight=bold);
65 keylegend /valueattrs=(Size=12 weight=bold);
66 run;
67 %mend;
68
69 ods rtf bodytitle file="U:\Documents\ARC Expenditure and Integrity\SinglePaneTrendPlot_071519.rtf";
NOTE: Writing RTF Body file: U:\Documents\ARC Expenditure and Integrity\SinglePaneTrendPlot_071519.rtf
70 title 'New Category Full Alcohol and Expenditure (N=412): Quadrimester Trend Plots';
71
72 %Quarter(sub.newcatinflation2,TLFPL ,Q, Inflation-Adjusted Dollars, Quadrimester Trend for Financial and Legal Affairs );
NOTE: Table WORK.TLFPL_Q created, with 3 rows and 6 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.51 seconds
cpu time 0.04 seconds
NOTE: There were 3 observations read from the data set WORK.TLFPL_Q.
NOTE: The data set WORK.TLFPL_Q has 6 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
NOTE: There were 6 observations read from the data set WORK.TLFPL_Q.
NOTE: The data set WORK.TLFPL_Q has 6 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
NOTE: There were 6 observations read from the data set WORK.TLFPL_Q.
NOTE: The data set WORK.TLFPL_Q has 6 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
NOTE: PROCEDURE SGPANEL used (Total process time):
real time 0.49 seconds
cpu time 0.18 seconds
NOTE: There were 6 observations read from the data set WORK.TLFPL_Q.
73 %Quarter(sub.newcatinflation2,DurInsHouse ,Q, Inflation-Adjusted Dollars, Quadrimester Trend for Housing/Insurance/Durable Goods );
NOTE: Table WORK.DURINSHOUSE_Q created, with 3 rows and 6 columns.
NOTE: PROCEDURE SQL used (Total process time):
3 The SAS System 14:30 Monday, July 15, 2019
real time 0.04 seconds
cpu time 0.03 seconds
NOTE: There were 3 observations read from the data set WORK.DURINSHOUSE_Q.
NOTE: The data set WORK.DURINSHOUSE_Q has 6 observations and 4 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
NOTE: There were 6 observations read from the data set WORK.DURINSHOUSE_Q.
NOTE: The data set WORK.DURINSHOUSE_Q has 6 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
NOTE: There were 6 observations read from the data set WORK.DURINSHOUSE_Q.
NOTE: The data set WORK.DURINSHOUSE_Q has 6 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
NOTE: PROCEDURE SGPANEL used (Total process time):
real time 0.28 seconds
cpu time 0.07 seconds
NOTE: There were 6 observations read from the data set WORK.DURINSHOUSE_Q.
74
75 ods rtf close;
76
77 GOPTIONS NOACCESSIBLE;
78 %LET _CLIENTTASKLABEL=;
79 %LET _CLIENTPROCESSFLOWNAME=;
80 %LET _CLIENTPROJECTPATH=;
81 %LET _CLIENTPROJECTNAME=;
82 %LET _SASPROGRAMFILE=;
83
84 ;*';*";*/;quit;run;
85 ODS _ALL_ CLOSE;
86
87
88 QUIT; RUN;
89
To me, everything looks kosher here.
How do you use RTF Close? I am using it like this:
ods rtf bodytitle file="U:\Documents\ARC Expenditure and Integrity\SinglePaneTrendPlot_071519.rtf";
title 'New Category Full Alcohol and Expenditure (N=412): Quadrimester Trend Plots';
%Quarter(sub.newcatinflation2,TLFPL ,Q, Inflation-Adjusted Dollars, Quadrimester Trend for Financial and Legal Affairs );
%Quarter(sub.newcatinflation2,DurInsHouse ,Q, Inflation-Adjusted Dollars, Quadrimester Trend for Housing/Insurance/Durable Goods );
ods rtf close;
I attempted to attach the RTF file which shows that each macro was invoked and used the new category. For instance, TLFPL and DurInsHouse will have different graphs in the RTF file but no titles- not even in the header. Whereas the "results" on the SAS Report are the pictures above. They have different titles, but they appear to only be graphing the last macro command evoked. In this case, that was the DurInsHouse.
Click image to register for webinar
