The SAS Output Delivery System and reporting techniques

How to freeze the vertical headers.

Reply
Contributor
Posts: 26

How to freeze the vertical headers.

Dear All.

                         

                                

AABBCCDDEE
A
B
C
D
E
F

Above the sample of my Report.

In that i had 25 Columns(like AA BB CC DD EE ..........).

But Row are 6 only like A B C D E F.

Now i need to freeze the A B C D E F in html page.So that i can see them how much am scrolling also.

Kindly help me

Regards,

Sravan

SAS Super FREQ
Posts: 8,715

Re: How to freeze the vertical headers.

hi:

  You did not say how you were creating ODS output. Are you using ODS HTML? Are you using ODS MSOFFICE2K or ODS TAGSETS.MSOFFICE2K_X???

  ODS TAGSETS.MSOFFICE2K_X is an HTML-based destination that does have a suboption to freeze column headers and row headers. The suboptions are: FROZEN_HEADERS and FROZEN_ROWHEADERS. But they will ONLY work with ODS TAGSETS.MSOFFICE2K_X or TAGSETS.EXCELXP. They will NOT work with ODS HTML. 

  For more information about the destination and usage of suboptions, see this web site:

http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html#Display There are a lot of code examples in the Tech Support topic.

cynthia

Contributor
Posts: 26

Re: How to freeze the vertical headers.

Dear Ma'am,

I need in HTML Format.

By using Proc Template i need to Freeze Kindly help me

Regards,

Sravan

SAS Super FREQ
Posts: 8,715

Re: How to freeze the vertical headers.

Hi:

  You do NOT need PROC TEMPLATE, if you want to create an HTML file that Excel can open and show you frozen headers. ODS MSOFFICE2K_X destination -is- an HTML-based destination. It has suboptions, as demonstrated on this site

http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html#Display

which allow you to freeze column headers (your AA, BB, CC, etc) and freeze row headers (your A B C D, etc.).

  The above site has sample code. You do not need to name your file as .XLS, you can use .HTML. This assumes that you want to open your file in Excel.

  If, however, you mean that you need to embed Javascript or other scripting commands to freeze headers in a browser, then you might want to open a track with Tech Support, if this lengthy note (with code) doesn't contain enough direction:

http://support.sas.com/kb/24/066.html

cynthia

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