1. How do I use the variable "siteid" values in title6?
2. Since the BY statement in proc report is using SITEID, it is automatically using siteid values in the title, but the problem is that I don't know how to customize it (eg. justify left, add text "siteid: siteidvalues")
%titles_footnotes(unblinded=&unblinded., progname=PD1);
title6 j=l 'Site:Siteid';
proc report data=final split='@';
by siteid;
columns var_order value_order indent_level c_1
define var_order / noprint order=internal order;
define value_order / noprint order=internal order;
define indent_level / noprint display;
define c_1 / ' ' display;
run
Please set the following option if you haven't already:
OPTIONS NOBYLINE;
Let me know if that gives you what you need.
Jim
One way to put variable values in titles is to use #ByVal. See: https://www.lexjansen.com/pharmasug/2006/TechnicalTechniques/TT01.pdf
Jim
that worked but I get an extra title (SITEID) that I can't get rid of (highlight in red). I tried adding extra blank titles but that didn't work.
Please set the following option if you haven't already:
OPTIONS NOBYLINE;
Let me know if that gives you what you need.
Jim
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.