topic How to get return code of a sh job which calls a sas job inside a macro in SAS Programming

How to get return code of a sh job which calls a sas job inside a macro

Sandy10 — Wed, 29 Nov 2017 03:35:50 GMT

I ahve to execute a batch scripts(sh script) which calls a SAS job inside a macro, I have to check the return code of the same . How to do ?

%do i=1 to &max;/*Max holds 9 thats 9 jobs*/

%let path = /app/jobs;

x "&path/&&jobs&i...&extn";/*extn is sh*/

%if rc ge 0 /*I have to do this but unabel to get rc value*/

Kindly advise

Thanks,
Sandhya S

Re: How to get return code of a sh job which calls a sas job inside a macro

Kurt_Bremser — Wed, 29 Nov 2017 05:44:14 GMT

First of all you need to make sure that the shell script returns the RC from SAS. After executing an external command, check the &sysrc automatic macro variable. It contains the return code from the x statement.

For reference, see here: http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=p07ugdul4v0llpn1denhfknmr7sb.htm&docsetVersion=9.4&locale=en

Re: How to get return code of a sh job which calls a sas job inside a macro

Sandy10 — Wed, 29 Nov 2017 07:11:14 GMT

Hi @Kurt_Bremser

Thanks for your reply. How to check the return code of a SAS job which was executed using below statement ?

%include /app/jobs/J_ABC.sas";

Thanks and Regards
Sandhya S

Re: How to get return code of a sh job which calls a sas job inside a macro

LinusH — Wed, 29 Nov 2017 07:23:47 GMT

%include execute the code in the calling session, hence no session rc.

Re: How to get return code of a sh job which calls a sas job inside a macro

Sandy10 — Wed, 29 Nov 2017 07:27:19 GMT

Hi @LinusH

I understand that . But if there anyway i can know whether the job is successful or not?

Re: How to get return code of a sh job which calls a sas job inside a macro

Kurt_Bremser — Wed, 29 Nov 2017 07:27:31 GMT

Since included code is always executed in the context of your local SAS, check &syscc for the current return code status.

You should also read through the documentation of the other automatic macro variables.

Re: How to get return code of a sh job which calls a sas job inside a macro

LinusH — Wed, 29 Nov 2017 09:44:01 GMT

Not sure what you mean by "Job" in this context.

For the "calling" session there will be a rc of course, but the included code is not a job.

If you want to monitor individual steps you can check rc for these.

If I try to read between the lines, I think you want to monitor each program separately, and the %include's are not a good choice.

Better to set job flows up in a decent scheduler, and have that as a central point of control.