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;
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.