BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
2 REPLIES 2
Cynthia_sas
Diamond | Level 26
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
deleted_user
Not applicable
Thank you. I was being dense. I blame it on being Friday!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1131 views
  • 0 likes
  • 2 in conversation