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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.