SAS Programming

DATA Step, Macro, Functions and more
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-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

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
  • 3115 views
  • 1 like
  • 2 in conversation