I am attempting to get a table created by a stored process to render with frozen column headers. I have referred to a number of support documents that explain ODS TAGSETS.TABLEEDITOR and only get partial success with the options. For example, autofilter="yes" does work in both IE 11 and Firefox 30, but frozen_headers ="yes" and frozen_rowheaders="1,2" don't seem to work, either separately or together. I have tried setting table height and width to ensure the table would not fill up the screen (what a mess looking at Google Chrome). I am creating the stored process using Enterprise Guide 4.3. When I look at the examples presented in the document Creating a Data Grid Like VB.NET, the frozen_headers.htm example also does not work. I was thinking I might have a local environment issue, but some of these options do work, so I'm stuck as to why the frozen headers won't work. Any ideas? Thanks.
Hi: TAGSETS.TABLEEDITOR works by embedding JavaScript in the HTML output. So first, if you are receiving the stored process output in a browser, JavaScript and scripting have to be allowed. When you create a stored process, your stored process could be run in PowerPoint (for example), but it would be a fruitless effort, in which the HTML/JavaScript is not used. PowerPoint, for example, can only receive SASReport XML type reports from stored processes.
My suspicion is that you have some kind of client application/HTML/JavaScript problem. The only folks who can debug that are Tech Support.
cynthia
I have tried on both PC and Mac using IE, Firefox and Chrome on PC and Safari, Firefox and Chrome on Mac. I have done this from different locations. In none of the browsers does the frozen headers example work from this document: Base SAS: Creating a Data Grid Like VB.NET
If there is some kind of HTML issue/JavaScript issue, it seems to have widespread impact that is really unrelated to whether I created the file in a stored process. I assume you mean contact SAS Tech Support. I'll do that. Thanks.
hi pylon53,
I have the same issue.
If I try the example for frozen headers from Base SAS: Creating a Data Grid Like VB.NET, it works from SAS Eguide (program running running on unix server).
But if I use it in a web-application STP (file=_webout), it doesn't. In the generated source is NO javascript.
Did you get any further?
thanks.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: