BookmarkSubscribeRSS Feed
LNM
Fluorite | Level 6 LNM
Fluorite | Level 6

When I run my proc report below:

proc report data=print04 nowindows missing spacing=1

style(report)={just=left} split='|';

by testing;

 

It prints testing on every page just like I want to. The title looks like this:

Testing=1000

 

I want to keep the '1000' which is the value of testing but remove the 'Testing=' part.  In short I just want '1000' to print by itself.

 

Thank you.

5 REPLIES 5
PaigeMiller
Diamond | Level 26
options nobyline;
title "#byval1";

 This goes before the PROC REPORT line.

--
Paige Miller
LNM
Fluorite | Level 6 LNM
Fluorite | Level 6

ods listing close;

options nonumber nodate orientation=portrait papersize=LETTER missing='';

ods escapechar= '!' noproctitle;

options nobyline;

ods pdf file="C:\testing_050718.pdf" style=styles.style1;

proc report data=print04 nowindows missing spacing=1

style(report)={just=left} split='|';

title "#testing";

 

I changed it above.  Now my title changed to #testing on every page. It's not giving me the value of testing which is 1000. Any more suggestions?

ballardw
Super User

The value #byval is a special value for use in title statements related to use of BY group processing. Do not change it to reflect your variable name. A suffix numeral such as #byval1 #byval3 indicates which variables value is displayed if more than one BY variables is used with the number referencing the variables from left to right. If you had a procedure using BY Name State Region City then a title using #byval4 would display the city variable value.

 

 

LNM
Fluorite | Level 6 LNM
Fluorite | Level 6
Thank you, your comment is very helpful.
LNM
Fluorite | Level 6 LNM
Fluorite | Level 6
It works beautifully. Thank you, Thank you!!
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
  • 5 replies
  • 2123 views
  • 2 likes
  • 3 in conversation