BookmarkSubscribeRSS Feed
pberg
Calcite | Level 5

Hello, I am working with PROC TEMPLATE and PROC REPORT / ODS HTML to produce a report that requires some additional features such as a fixed column header and also horizontal scrolling from right to left.  I've been able to code everything but the fixed column header within PROC TEMPLATE and then save as a custom style.

 

I have some code from a web programmer that should do the fixed column while scrolling but can't figure out how to incorporate this code into either PROC TEMPLATE or in the CSS sheet.  She simply inserted the code into the HTML produced by SAS but I need something more automated within SAS.

 

Has anyone done something like this and could share ideas/code?  Thanks Pat

2 REPLIES 2
Cynthia_sas
SAS Super FREQ
Hi: I thought there was an HTMLSCROLL destination that would allow you to scroll and do what you wanted. Take a look at this R&D web site http://support.sas.com/rnd/base/ods/odsmarkup/htmlscroll.html

cynthia
pberg
Calcite | Level 5
Hello and thanks for the tip. I have looked at this example but it is not quite what I need as I am using code to do right to left scrolling within the table. This is done in PROC TEMPLATE and is working fine but the freezing of the left hand most column is what I am stuck on right now.
Here is my TEMPLATE code for the scrolling (below). If I want to add some code like this to PROC TEMPLATE for the fixed column, is this possible? I have code written by another programmer but am not sure how to express it in PROC TEMPLATE.


proc template;
define style styles.test_withpanefromNA ;
parent=styles.sasweb;
style table from table /
outputwidth=99%
prehtml='<DIV
style="overflow:auto;
overflow-x: scroll;
overflow-y: visible;
direction: rtl;
WIDTH:100%;HEIGHT:visible "
id="data">
'
posthtml="</div>" ;
end ;
run ;

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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