how could I get outputs from stored procedure

bluewind123 — Wed, 21 Mar 2018 16:25:37 GMT

Hi there, I write a simple SAS stored procedure please see below, running a command from system, after it is finished, I want to publish a message to show the procedure finished, how could I do? Second, is there anyway I could return and publish the running results from the command I run from system? Please advise, thank you!

======

data _null_;
do;
call system ("ksh /xxx/cleanup_process.sh >> /xxx/crontabjob.log 2>&1");
call system ("echo cleanup_procee.sh is finished"); /*this doesn't work*/
end;
run;

Re: how could I get outputs from stored procedure

LinusH — Thu, 22 Mar 2018 05:25:01 GMT

To be able to return any message from s system call, use FILENAME PIPE instead.

For returning anything to the user there's a lot of documentation and papers on the subject.
Hint: _webout.

topic how could I get outputs from stored procedure in SAS Procedures

how could I get outputs from stored procedure

Re: how could I get outputs from stored procedure