The SAS Output Delivery System and reporting techniques

Can Column header

Reply
N/A
Posts: 0

Can Column header

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
SAS Super FREQ
Posts: 8,864

Re: Can Column header

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: Can Column header

Posted in reply to Cynthia_sas
Thank you. I was being dense. I blame it on being Friday!
Ask a Question
Discussion stats
  • 2 replies
  • 123 views
  • 0 likes
  • 2 in conversation