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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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