I have a question concerning PROC REPORT procedure. I’ll try to explain the problem:
Say, I want a report that contains one report item of GROUP type, one report item of ACROSS type and one report item of ANALYSIS type. If data set variable, that is defined as ACROSS report item, has 1000 different values, then there will appear 1000 + 1(for GROUP report item) columns in the report.
I want a report to be as HTML output. When I open the report using internet browser I see a very long table of the report stretching from left to right. If I want to look at the end of the report I have to scroll the report to the left. But then the column of GROUP report items’ values disappears from the browser window. The same happens when I scroll the report window up - the header disappears and I can not see the values of GROUP report item.
Are there any possibilities using SAS ODS to display fixed both header and left column when scrolling the report ? I mean that only the values of ANALYSIS report item would have the possibility to be scrolled ?
The EXCELXP tagset uses Spreadsheet Markup Language to create a file that you can open with Excel. The tagset has an option for freezing headers (on the top) and row headers (on the left). To see whether you have the version of the tagset that create this kind of file, submit a test job with this option:
ods tagsets.excelxp file='c:\temp\somefile.xls'
proc print data=whatever;
ods tagsets.excelxp close; [/pre]
The documentation for the ExcelXP tagset will be written to the SAS log. What you are looking for in the log is the Frozen_Headers and Frozen_RowHeaders option. If you do not see those options in your SAS log, that means you have to download the newest version of the tagset from the ODS MARKUP web site. I'll put the link below.
Also take a look at the tableEditor tagset which does something like this which you can find at the below FTP location. After extracting the zip file, click on the demo.html file to see the example code.