BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
HitmonTran
Pyrite | Level 9

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") 

HitmonTran_0-1623452595101.png

 

	%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
1 ACCEPTED SOLUTION

Accepted Solutions
jimbarbour
Meteorite | Level 14

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

OPTIONS NOBYLINE;

 

Let me know if that gives you what you need.

 

Jim

View solution in original post

3 REPLIES 3
jimbarbour
Meteorite | Level 14

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

 

Jim

HitmonTran
Pyrite | Level 9

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.

HitmonTran_0-1623457080450.png

 

jimbarbour
Meteorite | Level 14

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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 2685 views
  • 1 like
  • 2 in conversation