Date: Thu, 2 Sep 2004 23:57:51 -0400
Reply-To: "Chang Y. Chung" <chang_y_chung@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Chang Y. Chung" <chang_y_chung@HOTMAIL.COM>
Subject: Re: how can I freeze my table headers while I scroll the page?
On Thu, 2 Sep 2004 20:07:12 -0500, Srinivas Reddy
<reddy.srinivas@GMAIL.COM> wrote:
>Hello,
> Iam pretty new to this group. I am working on AIX system and
>use sas 8.2.
>I generate all of my html reports using SAS ODS.
>Most of my reports have results of the size of 100+ rows and 10+ columns.
>
>The Issue i have right now is , when i scoll the page, iam not going
>to see table headers
>and it becomes difficult to identify which column value corresponds to
what.
>
>I searched on Google and all i could find was this link in sas technical
faq :
>
>http://support.sas.com/faq/040/FAQ04035.html
>
>Can anybody help me with this ?
>
>I would like to freeze my table headers while I scroll the page?
>
>Remember that i am using SAS 8.2.
Hi, Reddy,
Yes. it would be very cool if you make it work better than what you have
already found.
I guess that you can possibly modify the table template or styles so that
you specify the column width in an absolute unit like pixels through css.
Then the vertical lines would line-up. But, in order to do that, you have
to calculate at least the maximum length of the column labels in pixel
unit, as well...
The examples you found are from the horse's mouth -- they seem to be
written by the very people who are involved in developing ods itself. I am
not sure how experienced you are with ods, but it would be difficult to
top what they have already done.
Eric once demonstrated, in a local sas users' group meeting, a cool
template he wrote to put the row headers of the table both on the left
*and* on the right ends. (Of course the right-end headers were the mirror
image of the left-end headers in such a way that the outter most
categories stayed at outter most columns at both ends, and so forth.
hint:ods@sas.com) Once you understood his code then you may be able to
modify it so that your tables show the column headers top *and* bottom, as
well.
Another possibility is to output an excel file (possibly in ms xml format)
with frozen header rows and to require your readers to use ms excel viewer
plug-in (free) for ms ie browser. I have not tried this so I am not sure
how easy it would be.
Just my $.02.
Cheers,
Chang
| 
