topic Re: Controlling "TITLE" OUTPUT in proc print. in ODS and Base Reporting

Controlling "TITLE" OUTPUT in proc print.

deleted_user — Tue, 29 Jan 2008 17:46:43 GMT

they way my report is set up right now is proc print prints N number of variables and report is broken down BY say variable x.

Problem is title is printing after each break in report example

state report <--- title

state employee
1 a
1 b
1 c
1 d

state report

state employee
2 a
2 b
2 c
2 d

I want title printed only once at the top of the report and using data step is not an option for me . I mean i tried to supress it thru blank title but it did not work it suppresed title period.

How do i do it ?

Re: Controlling "TITLE" OUTPUT in proc print.

David_SAS — Tue, 29 Jan 2008 18:58:51 GMT

Eugene,

You didn't say what kind of output you're generating. I assume that it's Listing. If so, you could try setting your system LINESIZE option to a suitably large value, say 10000, e.g.:
[pre]
options linesize=10000;
[/pre]

-- David Kelley, SAS

Re: Controlling "TITLE" OUTPUT in proc print.

deleted_user — Tue, 29 Jan 2008 19:05:38 GMT

David, i dont think it will work I already have linesize at MAX, and title output is not controled by how many lines report has but by "BY variable" ;

below is example code. BTW I am trying to generate spread sheet. I need title to print only once .
ODS HTML FILE=REPTDY STYLE=MINIMAL RS=NONE ;
OPTION NOBYLINE MISSING='' LINESIZE=MAX CENTER NONUMBER NODATE ;
PROC PRINT DATA=TODAYVOID;
TITLE "
COMMERCIAL REFUND REPORT FOR TODAY ";
VAR CONTRACT_NUM
AR_SEQ_NUM
LAST_UPDT_USER_ID ;
LABEL CONTRACT_NUM = ' CONTRACT NUMBER'
AR_SEQ_NUM = ' AR SEQUENCE NUMBER'
LAST_UPDT_USER_ID = ' USERID '
ACTION_CD = ' ACTION CODE'
BILL_AMT = ' FROM DOS' ;
BY CONTRACT_NUM ;
PAGEBY CONTRACT_NUM ;
RUN;

BTW forum does not want to paste my sample code correctly in order to see it lined up correctly clikc reply and press "quote original"
Message was edited by: EugeneG

Message was edited by: EugeneG Message was edited by: EugeneG

Re: Controlling "TITLE" OUTPUT in proc print.

David_SAS — Tue, 29 Jan 2008 19:30:37 GMT

Eugene,

Because you're using ODS HTML, you can try the TEXT= option, e.g.:
[pre]
title;
ods html file=reptdy style=minimal ... text="state report";

[...]

ods html close;
[/pre]
There's a possibility that you'll have to modify the UserText style element to get the desired appearance for the TEXT= text. I recommend that you follow up with Technical Support if that turns out to be the case.

-- David Kelley, SAS

P.S. The pre and /pre directives (enclosed in square brackets) will render preformatted text, which is handy for SAS code.

-- David Kelley, SAS