I have this visualization where I am trying to print the plot based on 'by' variables.
In order to specify which chart has which data, I am using #byline/#byval values to print them on top of chart using title statement.
Issue is that a static 'title' statement is being printed on the pages and I am not able to pin point where it is coming from
options nobyline leftmargin=.5in rightmargin=0.5in orientation=portrait nocenter;
ODS PDF FILE = "&outfiles./PDF/Transaction_Bucket.pdf" gtitle dpi=300;
ods graphics on / width=7in height=4.5in scale=on outputfmt=png;
options nobyline;
ods layout gridded columns=1 advance=table;
title height=10pt color=dabgr 'Source = #byval2 and Transaction Bucket = #byval1';
PROC sgplot DATA = _01_E_TXN_CLM_;
by BKT_TXN CLM_SOURCE;
vbar weekof/ response=AMT y2axis datalabelattrs=(size=8 family="Arial") datalabel=AMTK fillattrs=(color=aquamarine);
vline weekof/ response=TXN_CLM lineattrs=(color=red thickness=2) markerattrs=(symbol=CircleFilled color=red size=5) datalabel=TXN_CLM datalabelattrs=(size=8 family="Arial" color=red);
xaxis label= "Weeks" labelattrs=(size=8 family="Arial") valueattrs=(size=8 family="Arial");
yaxis label= "TXN / CLM" labelattrs=(size=8 family="Arial") valueattrs=(size=8 family="Arial") GRID VALUES = (0 TO 2.5 BY 0.2);
y2axis label= "Total Claim Amount" labelattrs=(size=8 family="Arial") valueattrs=(size=8 family="Arial");
keylegend / valueattrs=(size=8 family="Arial") location=outside position=BOTTOMRIGHT ;
RUN;
ods layout end;
ODS PDF CLOSE;
Please see the pdf to check for highlighted issue
This did not work,
instead of title now everywhere I am getting
"Source = #byval2 and Transaction Bucket = #byval1"
Add 'options nobyline;' to get rid of the default by-lines. Here's an example:
proc sort data=sashelp.class out=class;
by sex;
run;
options nobyline;
title 'byval = #byval1';
proc sgplot data=class;
by sex;
scatter y=height x=weight;
run;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.