topic Postcode not working when the DIS job failes in SAS Data Management

Postcode not working when the DIS job failes

Babloo — Mon, 16 Sep 2019 13:58:13 GMT

I've the post code in DIS Job which calls the .sas file via %INCLUDE Statement. It (post code) is working fine when DIS Job ends with success or warning. However it is not working when the DIS Job Fails and I could see the WARNING as follows. I'm not certain why I'm getting the WARNING only when DIS Job fails.

.sas file which was being called in INCLUDE Statement is not taking any value from the final table which was being created from the DIS Job. May I know how to resolve this issue when the DIS Job failes?

817        /*---- Start of Post-Process Code  ----*/
818        
819        %INCLUDE "/var/sasdata/ifr/SASCode/distudio/metadata_info.sas";
0



WARNING: RUN statement ignored due to previous errors. Submit QUIT; to terminate the procedure.
NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds

Re: Postcode not working when the DIS job failes

LinusH — Mon, 16 Sep 2019 14:43:48 GMT

The default behaviour is that no statements are executed in a SAS session when an error occurs.

Do you really need to execute your %include program when a job fails?

Please describe your requirement so we may can come up with an alternative approach.

Re: Postcode not working when the DIS job failes

Babloo — Mon, 16 Sep 2019 15:14:44 GMT

Yes, I really want to execute INCLUDE statements even when the job fails.

Whether I have to place the INCLUDE statement in some other place or can I
wrap up my .sas file which was being called in the INCLUDE statement and
call that macro in some portion of the job?

Re: Postcode not working when the DIS job failes

ErikLund_Jensen — Tue, 17 Sep 2019 16:28:56 GMT

Hi @Babloo

This is not tested, but I guess it could be solved by adding

option NOSYNTAXCHECK ;

as the first line in your includecode.