topic Re: proc report: suppress title repeating for each by group in ODS and Base Reporting

proc report: suppress title repeating for each by group

bheinsius — Tue, 01 Sep 2009 08:20:33 GMT

Hi,

Is there a way to suppress the title specified on the TITLE statement from repeating for every BY group in PROC REPORT?

-Bart

Re: proc report: suppress title repeating for each by group

David_SAS — Tue, 01 Sep 2009 13:31:21 GMT

Bart,

You could try replacing the TITLE statement with and ODS TEXT= statement.

-- David Kelley, SAS

Re: proc report: suppress title repeating for each by group

bheinsius — Tue, 01 Sep 2009 14:52:44 GMT

Hi David,

Thanks for your answer.

Using ODS TEXT= generates an error message:

ERROR 180-322: Statement is not valid or it is used out of proper order.

Is ods text sas92 only?

-Bart

Re: proc report: suppress title repeating for each by group

David_SAS — Tue, 01 Sep 2009 15:02:09 GMT

Bart,

ODS TEXT= is new to SAS 9.2:

http://support.sas.com/rnd/base/new92/92odsmore.html#odstext

SAS 9.1 has destination-specific TEXT=, e.g.:

ods pdf file="out.pdf" text="Hello World!';
ods html file="out.html" text="Hello World!";

-- David Kelley, SAS

Re: proc report: suppress title repeating for each by group

bheinsius — Tue, 01 Sep 2009 15:21:12 GMT

Hi David,

My program runs as a stored process, I think that ods html statements won't work there.

-Bart

Re: proc report: suppress title repeating for each by group

David_SAS — Tue, 01 Sep 2009 15:49:04 GMT

Bart,

I recommend contacting Technical Support. To do that, click "Contact Us" at the bottom of the forum web page.

-- David Kelley, SAS

Re: proc report: suppress title repeating for each by group

bheinsius — Thu, 10 Sep 2009 13:44:08 GMT

Hi,

I tracked the problem with Techsupp, they came up with the following solution, which works perfectly:

[PRE]

proc sort data=sashelp.class out=sorted;
by age;
run;

%put &_ODSDEST;
data _null_;
if "&_ODSDEST" eq "HTML" then
Ods html Text="Test Bart- EOM";
if "&_ODSDEST" eq "PDF" then
Ods PDF Text="Test Bart- EOM";
run;

proc report data=sorted nowindows;
column name sex weight;
by age;
define name / display;
define sex / display;
define weight / display;
run;

[/PRE]

Replacing:
[PRE]

Text="Test Bart- EOM"

[/PRE]
with:
[PRE]

Text="<span class=""c SystemTitle"">Test Bart- EOM</span>"

[/PRE]
preserves the title style.

- Bart

Added PRE tages around SAS code Message was edited by: bheinsius