DATA Step, Macro, Functions and more

Kill SAS Session via HTML in a Stored Process

Reply
Senior User
Posts: 1

Kill SAS Session via HTML in a Stored Process

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

 

 

Frequent Contributor
Posts: 149

Re: Kill SAS Session via HTML in a Stored Process

Posted in reply to CarlosFrancisco

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.

Super Contributor
Posts: 440

Re: Kill SAS Session via HTML in a Stored Process

Posted in reply to CarlosFrancisco

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.

Ask a Question
Discussion stats
  • 2 replies
  • 209 views
  • 0 likes
  • 3 in conversation