topic Re: Javascript visualisations (D3, google charts etc) in SAS EG browser not working? in SAS Enterprise Guide

Javascript visualisations (D3, google charts etc) in SAS EG browser not working?

invalid — Wed, 03 Jan 2018 15:06:07 GMT

Hi!

When i try to use Google Charts to make a Sankey Diagram in SAS eg i cant view it in the "SAS EG browser". If I right click and choose "open with windows default" then it works fine in Firefox.

Am I doing something wrong or are JS visualisations such as google charts not supported by the SAS eg ouput viewer browser?

My code:

filename _webout "out2.html";
data _null_;
 file _webout;
put ' <html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load("current", {"packages":["sankey"]});
      google.charts.setOnLoadCallback(drawChart);

      function drawChart() {
        var data = new google.visualization.DataTable();
        data.addColumn("string", "From");
        data.addColumn("string", "To");
        data.addColumn("number", "Weight");
        data.addRows([
          [ "A", "X", 5 ],
          [ "A", "Y", 7 ],
          [ "A", "Z", 0 ],
          [ "B", "X", 2 ],
          [ "B", "Y", 9 ],
          [ "B", "Z", 4 ]
        ]);
       
        var options = {
          width: 600,
        };

        var chart = new google.visualization.Sankey(document.getElementById("sankey_basic"));
        chart.draw(data, options);
      }
    </script>
  </head>
  <body>
    <div id="sankey_basic" style="width: 900px; height: 300px;"></div>
  </body>
</html>'
;;;;;;;
run;

The error I get in SAS EG when viewing the ouput there:

Best regards

Re: Javascript visualisations (D3, google charts etc) in SAS EG browser not working?

ChrisHemedinger — Wed, 03 Jan 2018 15:25:18 GMT

The embedded browser in EG is a hosted version of the Microsoft IE component that's built into Windows. You can change your EG preferences to always open HTML output in an external window (Chrome or FF). The embedded browser won't be able to run your scripts.

Re: Javascript visualisations (D3, google charts etc) in SAS EG browser not working?

snoopy369 — Wed, 03 Jan 2018 15:28:28 GMT

Ahah, I figured you'd come the moment I hit my answer button... Is the hosted version available somewhere to run (in order to test things) or is it hidden in a DLL and unaccessible outside? I expected to find an "iexplore.exe" or something similar hanging around somewhere in the SAS folders, but I couldn't find it.

Re: Javascript visualisations (D3, google charts etc) in SAS EG browser not working?

ChrisHemedinger — Wed, 03 Jan 2018 16:37:06 GMT

@snoopy369 - it's wrapped up in the WebBrowser control that's part of the .NET Framework. Under the surface, it is using some DLLs that are shared with IE. It would be simple to build a small app that could be used for testing, but there isn't a way (that I know of) to drive EG to do this for you.