topic Re: Is there a way to automatically close the window of a stored process when it's done? in Developers

Is there a way to automatically close the window of a stored process when it's done?

mathias — Thu, 24 Aug 2017 14:36:30 GMT

Hello,

I'm execting a STP in a new from my main web page.

<form target="_blank" action="http://<UrlToMySTP>" method="get" enctype="multipart/form-data">

And I would like it to close automatically when it's done.

I tried to do this in JavaScript,

data _null_;
    file _webout;
    put '<HTML>';
    put '   <HEAD>';
    put '   </HEAD>';
    put '   <BODY onLoad="window.close()">';
    put '   </BODY>';
    put '</HTML>';
    run;

but the browsers don't allow that (security vulnerability)

Scripts may close only the windows that were opened by it.

Is there another way to close the page?

Thanks!

Re: Is there a way to automatically close the window of a stored process when it's done?

Vince_SAS — Fri, 25 Aug 2017 12:29:25 GMT

Can you explain why you want to do that or what you're trying to achieve? There may be a different way to get the result that you need.

Vince DelGobbo

SAS R&D

Re: Is there a way to automatically close the window of a stored process when it's done?

mathias — Thu, 01 Feb 2018 10:59:33 GMT

When a button is clicked, something needs to be done in SAS, (for example delete a record in a table).

and that just needs to be done in a separate window

that window is empty is empty and doesn't need to stay open.

I wan to avoid the user having to close the empty window manually.

On another case I used a redirect, because I could afford a page refresh, not this time.

I found a way to just call the STP with ajax. But that was more difficult than I thought necessary.

Re: Is there a way to automatically close the window of a stored process when it's done?

AllanBowe — Thu, 01 Feb 2018 11:14:01 GMT

It is MUCH easier, and far better practice, to build web applications on SAS using AJAX and dedicated html / javascript than to try and build your web logic using put statements in a data step!

The process is also far easier given the availability of the Boemska open source h54s adapter. I did a post some time ago explaining how to use the adapter, and an SGF paper here.

The short story - build and deploy your web application logic (html/css/javascript) to the SAS Web Server, and your data step / backend logic (sas programs) to the SAS Application server. This will save a huge amount of trouble as your application complexity increases.

Re: Is there a way to automatically close the window of a stored process when it's done?

mathias — Thu, 01 Feb 2018 11:30:25 GMT

Yup! I have heard of it numerous times, even tried it.
But this tool requires the sas server and the web server to be on the same domain or server.
Which is never the case in my setups.
So I can't use h54s.

Re: Is there a way to automatically close the window of a stored process when it's done?

AllanBowe — Thu, 01 Feb 2018 11:35:06 GMT

The tool doesn't require it.. Your SAS server is configured to require it. You will have the same issue regardless of whether the adapter is used or not, if building web apps on SAS using ajax.

If your site does not permit your web files to be served from the SAS Web server, you can always ask for your preferred web server to be whitelisted. And use chrome with CORS disabled in the meantime. This approach is taken by many of our clients. It is far preferable to do these things properly than to have to maintain a web application composed of put statements / proc stream / whatever...

Re: Is there a way to automatically close the window of a stored process when it's done?

mathias — Thu, 01 Feb 2018 12:22:30 GMT

You don't have CORS issues when using "jsonp", no need to whitelist the webserver on the sasserver.

(at least I don't, maybe it's different on different setups)

And the put statements that write an empty html page are very little in this case.

Re: Is there a way to automatically close the window of a stored process when it's done?

boemskats — Tue, 06 Feb 2018 14:04:28 GMT

Hi Mathias,

The thing with JSONP is that you can't make POST requests, which means you're limited to simple URL-encoded parameter values when sending data to SAS. It's also... a bit of a hack.

I'm not a fan of it, but I'll have a chat to our devs and see if there's a way we can implement it as an optional transport mechanism. Will keep you posted.

Nik