topic Proc report title- how to put variable values in title in SAS Programming

Proc report title- how to put variable values in title

HitmonTran — Fri, 11 Jun 2021 23:04:00 GMT

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

Re: Proc report title- how to put variable values in title

jimbarbour — Fri, 11 Jun 2021 23:27:49 GMT

One way to put variable values in titles is to use #ByVal. See: https://www.lexjansen.com/pharmasug/2006/TechnicalTechniques/TT01.pdf

Jim

Re: Proc report title- how to put variable values in title

HitmonTran — Sat, 12 Jun 2021 00:18:26 GMT

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.

Re: Proc report title- how to put variable values in title

jimbarbour — Sat, 12 Jun 2021 01:21:10 GMT

Please set the following option if you haven't already:

OPTIONS NOBYLINE;

Let me know if that gives you what you need.

Jim