topic Re: Can Column header in ODS and Base Reporting

Can Column header

deleted_user — Fri, 20 Jun 2008 18:05:00 GMT

I have a SP Proc Report that we run on the Portal.
One of the output choices is HTML. While the PDF export will repeat the column header on each page, I cannot figure out how to repeat the header on HTML. Since there is no true page on HTML, I would want to do the column header at each break.
Is this possible?
In the example below, the column header should repeat again after the level2 break:

proc sort data=SASHELP.COMPANY
out=sortcmy;
by level2;
run;

proc report data=work.sortcmy nowd;
title "Company";
column level1 level2 level5;
define level1 / group 'Company';
define level2 / group 'Country';
define level5 / display 'Emp';

break after level2 / ol skip ;
run;

Thank you
-Patrick

Re: Can Column header

Cynthia_sas — Fri, 20 Jun 2008 20:56:11 GMT

Hi:
Try modifying your BREAK AFTER statement like this:
[pre]
break after level2 / page;
[/pre]

with the PAGE option. I removed OL and SKIP because those are ignored by ODS HTML, RTF and ODS PDF. For ODS HTML, this should put a Horizontal rule between each logical "page" (even though HTML is not a paged destination) but it should also repeat the column headers for you.

cynthia

Re: Can Column header

deleted_user — Fri, 20 Jun 2008 21:25:36 GMT

Thank you. I was being dense. I blame it on being Friday!