The SAS Output Delivery System and reporting techniques

PROC REPORT and freeze headline when scrolling

Reply
Occasional Contributor
Posts: 12

PROC REPORT and freeze headline when scrolling

Hello,

 

how can i freeze the headline in PROC REPORT when i scroll the page? Is this possible?

 

Thank you very much

 

Best regards

George

Respected Advisor
Posts: 3,271

Re: PROC REPORT and freeze headline when scrolling

If you are outputting the results of PROC REPORT to Excel via ODS EXCEL or ODS TAGSETS.EXCELXP, then freezing the top row in place is possible, as this is a feature of Excel.

 

ods excel file="myfolder\ods_excel_example.xlsx" options(frozen_headers="ON");

 

If you are outputting the results to some other destination, it probably isn't possible as there is no concept of freezing the top row in the other destinations.

--
Paige Miller
SAS Super FREQ
Posts: 9,431

Re: PROC REPORT and freeze headline when scrolling

Posted in reply to PaigeMiller
Hi:
And, there's this https://support.sas.com/rnd/base/ods/odsmarkup/htmlscroll.html for HTML, but I haven't tried this in a while and I believe it was written for HTML3.2 or HTML4, so I'm not sure how it would work in the HTML5 world.

cynthia
Occasional Contributor
Posts: 12

Re: PROC REPORT and freeze headline when scrolling

Thank you very much.

 

Of course - I need it for HTML...Smiley Happy I hope the tutorial will work also with new browsers.

Ask a Question
Discussion stats
  • 3 replies
  • 157 views
  • 0 likes
  • 3 in conversation