topic Re: Limit titles to first page in ODS and Base Reporting

Limit titles to first page

hari1109 — Thu, 17 Mar 2011 04:09:59 GMT

Thank you in advance..

I have a dataset that has more than 500 records and i have to produce a pdf file output
out of it using ods pdf destination in sas enterprise guide but the titles are appearing in every page which i don't want. I have titles with macro variables in it and they should appear in only first page. i tried using compute block with _page_ but by doing so i am getting line statements in all pdf pages. Is there any way to restrict titles to first page?
Thank you.

Re: Limit titles to first page

Ksharp — Thu, 17 Mar 2011 06:19:30 GMT

Hi.
You can use a " proc print " before " proc report " .

Ksharp

Re: Limit titles to first page

Cynthia_sas — Thu, 17 Mar 2011 14:50:19 GMT

Hi:
Or, you could use two PROC REPORT steps. The bottom line, is that you have to figure out how many obs "fit" on the first page. For the default style, using SASHELP.SHOES, I can get 33 obs on the first page with 1/2 inch margins at the top and bottom of the page:
[pre]
options orientation=portrait topmargin=.5in bottommargin=.5in nodate nonumber;
title; footnote;
ods pdf file='c:\temp\onlyfirst.pdf' notoc;

proc report data=sashelp.shoes(firstobs=1 obs=33) nowd;
column region subsidiary product sales inventory returns;
title 'Title on First Page Only';
run;

title; /* clears previous title */
proc report data=sashelp.shoes(firstobs=34 obs=max) nowd;
column region subsidiary product sales inventory returns;
run;

ods _all_ close;
[/pre]

Since the TITLE statement can only be cleared between procedure steps, the second proc report picks up displaying observations with firstobs=34, but AFTER the title has been cleared with a null TITLE statement.

cynthia

Re: Limit titles to first page

polingjw — Thu, 17 Mar 2011 15:07:56 GMT

Of course, this solution assumes that you have no summary lines in the report. When you have summary lines in the report, splitting the dataset into two parts does not work. I have also run into this problem and I never found an acceptable alternative. See http://support.sas.com/forums/thread.jspa?messageID=40487鸧.

Re: Limit titles to first page

Cynthia_sas — Thu, 17 Mar 2011 15:31:27 GMT

You're right -- if you need any kind of summary information that includes what was on the first "page" then you have to do some fiddling to make it work -- but that's the difference between a word processor (that allows you to treat the first page differently from the other pages) and a report generator -- that treats the titles and footnotes as "global" statements which apply to the whole report.

You can't analyze 10 years of census data in Word, but you can get a separate title on the first page. You CAN analyze and report on 10 years of census data in SAS -- but by default all pages on the report get the same title. SAS isn't a Word processor -- SAS, using ODS, can create Word processor readable documents -- but with limits.

cynthia

Re: Limit titles to first page

hari1109 — Thu, 17 Mar 2011 18:36:05 GMT

Thank you guys for the suggestions. i will look into those and let you know if it is working.

Re: Limit titles to first page

ballardw — Thu, 17 Mar 2011 20:24:21 GMT

Possibly using ODS PDF Text="" before your procedure call. Add appearance options as needed/available.<BR /> <BR /> I don't use PDF much but have done this MANY times for RTF output when I have similar needs.

Re: Limit titles to first page

hari1109 — Sun, 20 Mar 2011 03:59:07 GMT

I used the code
Cynthia has suggested and it is working fine. Thank you very much.

Re: Limit titles to first page

santos_stats — Thu, 19 Apr 2012 18:47:42 GMT

Just Signed up to Thank Cynthia. It has been a hell of a problem for me before I visited this forum.

Thank You again Cynthia.

Re: Limit titles to first page

SASFiddler — Fri, 11 Oct 2019 08:21:40 GMT

Print with title and report without title:

ods ...
title2 'AAAAAA';

proc print data=...;
var ...;
label ...
run;

title2 '';
proc report data=...;
column ...;
by ...;
DEFINE ...;
format ...;
run;
ods ...

Re: Limit titles to first page

SASdevAnneMarie — Mon, 09 Mar 2020 17:27:46 GMT

Hello,

I would like to have ods rtf with title only in the fisrt page.

I tried your code (for pdf), I have the title on the 2 first pages:

ods pdf file='\\XXXXXXXX\TEST\onlyfirst.pdf' notoc;

proc report data=sashelp.shoes(firstobs=1 obs=33) nowd;
column region subsidiary product sales inventory returns;
title 'Title on First Page Only';
run;

title; /* clears previous title */
proc report data=sashelp.shoes(firstobs=34 obs=max) nowd;
column region subsidiary product sales inventory returns;
run;

ods _all_ close;

Maybe you know some option to do that?

Thank you very much!

Re: Limit titles to first page

Cynthia_sas — Mon, 09 Mar 2020 19:35:17 GMT

Hi:

I do not have that experience with your code, SASHELP.SHOES and ODS PDF, as shown below:

Without knowing your orientation and margin options, I could not completely replicate your experience, but I used the options shown in the above screen shot and the title on page 1 worked for me. If you use the SAME options and orientation and margins and still get the title starting on page 2, then you might want to open a track with Tech Support for deeper investigation about your system settings.

Cynthia

Re: Limit titles to first page

SASdevAnneMarie — Tue, 10 Mar 2020 09:18:57 GMT

Thank you Cynthia.

My problem is that I want the landscape format for my report.

This code does not work with landscape option.

Maybe you have some idea for additional option with lanscape format please. My code is:

options orientation=landscape topmargin=.5in bottommargin=.5in nodate nonumber;

title; footnote;
ods rtf file='\\XXXXXXXXXXXXXX\4. Résultats excel\3. Publipostage\TEST\onlyfirst.doc' ;
proc report data=sashelp.shoes(firstobs=1 obs=33) nowd;
column region subsidiary product sales inventory returns;
title 'Title on First Page Only';
run;

title;
proc report data=sashelp.shoes(firstobs=34 obs=max) nowd;
column region subsidiary product sales inventory returns;
run;

ods _all_ close;

Re: Limit titles to first page

SASFiddler — Tue, 10 Mar 2020 09:23:13 GMT

ods pdf file='\\XXXXXXXXXX\onlyfirst.pdf' notoc;
options NOBYLINE;
proc report data=sashelp.shoes nowd;
column region subsidiary product sales inventory returns;
by Region Subsidiary;
title 'Title on First Page Only "#BYLINE"';
run;

ods _all_ close;

That may help some.

Re: Limit titles to first page

SASdevAnneMarie — Tue, 10 Mar 2020 09:49:58 GMT

Hello,

Thank you for the code.

Unfortunately,

I have the same proble: the title on the ALL pages:

My programme is:

ods pdf file='\\XXXXXX\TEST\onlyfirst.pdf' notoc;
options NOBYLINE;
proc report data=sashelp.shoes nowd;
column region subsidiary product sales inventory returns;
by Region Subsidiary;
title 'Title on First Page Only "#BYLINE"';
run;

ods _all_ close;

Re: Limit titles to first page

SASFiddler — Tue, 10 Mar 2020 10:26:14 GMT

You could use an additional variable to indicate the first page;

ods pdf file='\\helsinki1.hki.local\kymp\Maankäyttö\Tutkimukset_ja_selvitykset\Liikennetutkimus\Helmi\Liikennelaskennat\onlyfirst.pdf' notoc;
options NOBYLINE;
proc report data=sashelp.shoes nowd;
column region subsidiary product sales inventory returns;
by Region Subsidiary;
title 'Title on First Page Only "#BYLINE"';
run;
options BYLINE;

ods _all_ close;

Re: Limit titles to first page

SASdevAnneMarie — Tue, 10 Mar 2020 10:31:24 GMT

Thank you, still does not work for me, I have the titles on ALL pages:

ods pdf file='\\XXXXXX\4. Résultats excel\3. Publipostage\TEST\onlyfirst.pdf' notoc;
options NOBYLINE;
proc report data=sashelp.shoes nowd;
column region subsidiary product sales inventory returns;
by Region Subsidiary;
title 'Title on First Page Only "#BYLINE"';
run;
options BYLINE;

ods _all_ close;

Re: Limit titles to first page

SASFiddler — Tue, 10 Mar 2020 11:32:14 GMT

ods pdf file='\\XXXXXXXXXXXXXXXX\onlyfirst.pdf' notoc;

data test;
set sashelp.shoes;
rownum=_n_;
run;
data test1;
set test;
if rownum<34;
run;
data test2;
set test;
if rownum>33;
run;
proc report data=test1 nowd;
column region subsidiary product sales inventory returns;
title 'Title on First Page Only';
run;
proc report data=test2 nowd;
column region subsidiary product sales inventory returns;
title;
run;

ods _all_ close;

Re: Limit titles to first page

Cynthia_sas — Tue, 10 Mar 2020 16:12:34 GMT

Hi:

Using the default style, I could NOT get 33 obs on a landscape page, so I changed just a few things -- I made the margins even smaller, but at best, I had to change the first page to only hold 26 obs not the 33 you had,

And here's the output, as I expected, with the title only on the FIRST page:

The ONLY way I discovered to get 33 obs on the first page was to override the cellpadding, as shown below:

However, this all works for me with ODS PDF and SASHELP.CARS -- I can get the title just on the first page in landscape or portrait.

If you run similar code and you get the title on ALL pages in the landscape PDF file, even after adjusting the number of obs, that is a problem that needs to be reported to Tech Support.

Cynthia

Re: Limit titles to first page

SASFiddler — Wed, 11 Mar 2020 11:54:31 GMT

https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-PDF-Shrinking-output-to-fit-to-one-page/td-p/1232

Hope this still works.