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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.