topic Re: PROC REPORT and freeze headline when scrolling in ODS and Base Reporting

PROC REPORT and freeze headline when scrolling

sorosch — Fri, 06 Apr 2018 12:16:31 GMT

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

Re: PROC REPORT and freeze headline when scrolling

PaigeMiller — Fri, 06 Apr 2018 12:19:51 GMT

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.

Re: PROC REPORT and freeze headline when scrolling

Cynthia_sas — Fri, 06 Apr 2018 16:38:26 GMT

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

Re: PROC REPORT and freeze headline when scrolling

sorosch — Mon, 09 Apr 2018 10:21:28 GMT

Thank you very much.

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