I think I've solved this before but can't remember if it was exactly the same - but here is the problem.
I'm creating a custom format in SAS and then creating a treemap (using gtile) to create a html page on a server. In sas results windows everything looks fine, but when you open the html file on the server the format on the data tips is gone. Any ideas?
ods listing close;
ods html file="treemap.html";
goptions reset=all device=activex;
proc gtile data=aaa; format totalbalance sterling.;
colorramp=(red white green)
ods html close;
I'm confused about what the issue is. Is the issue that you cannot see a picture at all, that you cannot see the tool tips at all or that you are not seeing the pound sterling sign with the format applied to the tool tips? I ran a modified version of your code using SASHELP.PRDSALE, but with your format for ACTUAL and PREDICT, using SAS 9.3 and I do see the pound sterling sign. So, you might want to consider opening a track with Tech Support if you are not seeing the tool tips as you expect.
Hi, when i output the html i output it to another server address, and when i access the html from that server via internet explorer the formats are lost. If i output to the server i have sas running on then the format remains in place either through the sas results window or internet explorer. The server that I am placing the html on has the sas graph activex programme installed but there seems to an issue in moving the custom format over to the new server - hope that makes sense.
for further clarity I can see the picture, i can drill down and everything works as normal and as should except that the tool tips do not have the applied formats. Further, I've just discovered that if i use internet explorer on the server with sas to open the file on the other server i see the formats! I'm clearly missing an add-in or some process for the non-sas server. hope that makes it clearer.
I'm using ie9 on the server that doesn't work (just lost formats) and i think it's ie8 on the server that does. I can't upload the html as it contains confidential information about the size of the business i work in - sorry - but i checked it out and at the end there is definitely a reference to the bespoke format if that helps.
And what version of the SAS/Graph Activex Control is installed into each of those browsers?...
(The reason this is important is that user-defined-formats have not always been supported, and even after they were supported there were a few enhancements/bug-fixes in various versions along the way...)
When you view the output that does, and doesn't, work ... are you viewing them using the exact same IE browser session? ... Or two different browser sessions? (on different machines?)
If two different browser sessions, are they running the exact same version of IE? And do they both have the exact same version of the SAS/Graph Activex Control? (right-mouse-button -> Help -> About Graph Control)
two different browser sessions, each on a different machine. the one that doesn't work is ie9 (sas/graph activex version 220.127.116.1158.32) and ie8 (sas/graph activex version 18.104.22.16858.32). interestingly it doesn't work for standard formats either (tried it with dollarx. but nothing). I now have a scenario where the version 8 browser shows the £ and comma formats and the version 9 browser shows a range 0-1 on the colorramp and a blank space in the tool tip. I unfortunately do not have access to a version 9/8 browser on each of the servers so i can't test machine spec and my version 8 ie at home also doesn't show the £ sign which suggests it's missing a base sas component/background file?
There seems to be an even bigger problem in that the numerical value displayed in the tool tip for the specified colorvar variable is incorrect - it's only correct when there is only 1 variable specified in the tileby statement. This is clearly something to do with my dataset and missing values as the process works on sashelp datasets - I'll try and fix and see if that help/impacts formats!
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.