Trigger Stored Process without producing output? Just SQL statement

[imdickson]

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?

[Vince_SAS]

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=p184mqqbi9w6qjn1q061... 

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=p184mqqbi9w6qjn1q061... 

Vince DelGobbo

SAS R&D