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

[Sandy10]

Hi

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

[Kurt_Bremser]

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&docset...

[Sandy10]

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

[Kurt_Bremser · Accepted solution]

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.

[LinusH]

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

[Sandy10]

Hi @LinusH

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

[LinusH]

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.