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
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
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.