When I run my proc report below:
proc report data=print04 nowindows missing spacing=1
style(report)={just=left} split='|';
by testing;
It prints testing on every page just like I want to. The title looks like this:
Testing=1000
I want to keep the '1000' which is the value of testing but remove the 'Testing=' part. In short I just want '1000' to print by itself.
Thank you.
options nobyline;
title "#byval1";
This goes before the PROC REPORT line.
ods listing close;
options nonumber nodate orientation=portrait papersize=LETTER missing='';
ods escapechar= '!' noproctitle;
options nobyline;
ods pdf file="C:\testing_050718.pdf" style=styles.style1;
proc report data=print04 nowindows missing spacing=1
style(report)={just=left} split='|';
title "#testing";
I changed it above. Now my title changed to #testing on every page. It's not giving me the value of testing which is 1000. Any more suggestions?
The value #byval is a special value for use in title statements related to use of BY group processing. Do not change it to reflect your variable name. A suffix numeral such as #byval1 #byval3 indicates which variables value is displayed if more than one BY variables is used with the number referencing the variables from left to right. If you had a procedure using BY Name State Region City then a title using #byval4 would display the city variable value.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.