The SAS Output Delivery System and reporting techniques

proc report

Reply
Occasional Contributor LNM
Occasional Contributor
Posts: 7

proc report

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.

Respected Advisor
Posts: 3,277

Re: proc report

[ Edited ]
options nobyline;
title "#byval1";

 This goes before the PROC REPORT line.

--
Paige Miller
Occasional Contributor LNM
Occasional Contributor
Posts: 7

Re: proc report

Posted in reply to PaigeMiller

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?

Super User
Posts: 13,941

Re: proc report

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.

 

 

Occasional Contributor LNM
Occasional Contributor
Posts: 7

Re: proc report

Thank you, your comment is very helpful.
Occasional Contributor LNM
Occasional Contributor
Posts: 7

Re: proc report

Posted in reply to PaigeMiller
It works beautifully. Thank you, Thank you!!
Ask a Question
Discussion stats
  • 5 replies
  • 241 views
  • 2 likes
  • 3 in conversation