topic Re: Kill SAS Session via HTML in a Stored Process in SAS Programming

Kill SAS Session via HTML in a Stored Process

CarlosFrancisco — Fri, 02 Jun 2017 11:26:45 GMT

Hi all,

I'm trying to kill my SAS Session in an alert message created by my Stored Process Output.

Currently i have this macro:

%macro output(output_tp);

%if &output_tp = 1 %then %do;
 DATA _NULL_;
 file _webout ;
 val = '<script type="text/JavaScript"> if (confirm("Adhoc Loading, do you wish to abort the process?"))
 { 
 alert("Process Terminated");
 }
 </script>';
 put val;
 run;
 %end;

%mend output;

%output(1);

After the alert "Process Terminated" i would like to execute something like x "kill -9 &SYSJOBID" but i don't know how to do it inside HTML.

Using 9.3 in Solaris

Best regards and thanks a lot for your help,

Carlos Francisco

Re: Kill SAS Session via HTML in a Stored Process

error_prone — Tue, 17 Oct 2017 07:58:42 GMT

The good news: You can't do this inside html. The corresponding sas-process has not been started just for the job you are terminating. The process will be re-used to run other stored processes and eventually be killed after some time of inactivity - depends on configuration. Using endsas command inside stored process code is not recommended.

Re: Kill SAS Session via HTML in a Stored Process

ChrisBrooks — Tue, 17 Oct 2017 08:11:46 GMT

As @error_prone said this wouldn't be a good idea even if it were possible. One of the big advantages of running a SAS Stored Process Server is that you effectively have a pool of available sessions which will be used to quickly execute Stored Processes without the start-up costs associated with creating new sessions. My advice would be the same as @error_prone - just leave well alone, they won't be using much resource until you need them.