topic Trigger Stored Process without producing output? Just SQL statement in Developers

Trigger Stored Process without producing output? Just SQL statement

imdickson — Wed, 16 Oct 2019 10:45:58 GMT

Hi there. I am a SAS Developer that deal with BASE SAS Programming and SAS Enterprise Case Management.

At the moment, I want to trigger a stored process code that only does Proc Sql to delete data from database.

However, once i integrate this trigger process in ECM XML file, it will prompt

The SAS program did not produce any output.

I then put a dummy command

%stpbegin;

%put xxx;

data a;

b=1;

run;

%stpend;

Still, it will either redirect me to the result page of dataset a or totally blank if i remove that datastep.

Is there a way that i can just put PROC SQL delete statement into the stored process script and it will only execute the Delete statement without my ECM redirecting me to anywhere?

Re: Trigger Stored Process without producing output? Just SQL statement

Vince_SAS — Thu, 17 Oct 2019 12:21:50 GMT

Specify a value for the _STATUS_MESSAGE macro variable to avoid the "no output" message:

https://go.documentation.sas.com/?docsetId=stpug&docsetVersion=9.4&docsetTarget=p184mqqbi9w6qjn1q0619x19eg02.htm#p0idgismz12mpln1ozzx9idnwpfg

proc sql; ... ; quit;

%let _STATUS_MESSAGE=Program finished.;

If you need a more elaborate message then you can use DATA step code:

proc sql; ... ; quit;

data _null_;
file _webout;
put '<h1>Program finished.</h1>';
run;

Or you can use background processing by specifying _ACTION=background.

https://go.documentation.sas.com/?docsetId=stpug&docsetVersion=9.4&docsetTarget=p184mqqbi9w6qjn1q0619x19eg02.htm#p09p75k3qtmrc7n1kkyv5s9a24us

Vince DelGobbo

SAS R&D