BookmarkSubscribeRSS Feed
sorosch
Fluorite | Level 6

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

3 REPLIES 3
PaigeMiller
Diamond | Level 26

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
Cynthia_sas
Diamond | Level 26
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
sorosch
Fluorite | Level 6

Thank you very much.

 

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 3 replies
  • 2947 views
  • 0 likes
  • 3 in conversation