topic Re: SAS code working properly in Base SAS but not working in Batch mode in SAS Programming

SAS code working properly in Base SAS but not working in Batch mode

chandusaladi — Tue, 01 Nov 2016 06:32:23 GMT

I am using the following code to generated error messages that occured during the SAS job run

the issue is when i am runnning the code through workspace server/EG it is sending the mail alerts where as when i scheduled it and run through the batch server it is not sending the mail alerts where as "abortcancel" statement is executed which is in the same macro

when an error occurs

PS: SMTP is configured in both workspace and batch mode in similar way

%macro ab_stop;
/* &syserr is a default macro variable which is generated internally in SAS */
%if not (&syserr eq 0 or &syserr eq 4) %then %do;
FILENAME Mailbox EMAIL TO=('XXXX@YYY.com')
CC=('support@yyy.com')
Subject='JOB FAILURE!!!';
DATA _NULL_;
FILE Mailbox;
PUT "job failed due to following error";
PUT "&SYSERRORTEXT";
RUN;
%abort cancel;
%end;
%mend;

proc sql;
create table temp1 as
select *
from sba.cars;
quit;

%ab_stop;

proc sql;
create table temp2 as
select *
from sashelp.cars;
quit;

%ab_stop;

Thanks inadvance

Re: SAS code working properly in Base SAS but not working in Batch mode

LinusH — Tue, 01 Nov 2016 07:08:23 GMT

What about providing the log?

Re: SAS code working properly in Base SAS but not working in Batch mode

SASKiwi — Tue, 01 Nov 2016 07:12:58 GMT

How are you running your batch jobs? If you are using a scheduler, then it can usually email you if a job fails so no coding is required. That is what we do and it is simple and reliable.

Re: SAS code working properly in Base SAS but not working in Batch mode

chandusaladi — Tue, 01 Nov 2016 07:17:07 GMT

the Current environment doesn't have SAS scheduler license so we are using OS scheduler which don't have capability to send mail alerts

Re: SAS code working properly in Base SAS but not working in Batch mode

chandusaladi — Tue, 01 Nov 2016 07:25:17 GMT

Following is the log when i run the program through Batch server

/* Macro to abort code at that particular step in case of an error and send to the Error*/
64
65 %macro ab_stop;
66 /* &syserr is a default macro variable which is generated internally in SAS */
67 %if not (&syserr eq 0 or &syserr eq 4) %then %do;
68 FILENAME Mailbox EMAIL TO=('XXX@YYY.com')
71 CC=('xxxx@yyy.com'
72 'xxx@yyy.com')
73 Subject='JOB FAILURE!!!';
74 DATA _NULL_;
75 FILE Mailbox;
4 The SAS System 10:00 Monday, October 31, 2016

76 PUT "job failed due to following error";
77 PUT "&SYSERRORTEXT";
78 RUN;
79 %abort cancel;
80 %end;
81 %mend;
82

proc sql;
create table temp1 as
select *
from sba.cars;
quit;

ERROR:Libref SBA is not assigned.

ERROR: Execution canceled by an %ABORT CANCEL statement.
NOTE: The SAS System stopped processing due to receiving a CANCEL request.

Re: SAS code working properly in Base SAS but not working in Batch mode

Kurt_Bremser — Tue, 01 Nov 2016 09:12:16 GMT

That

ERROR:Libref SBA is not assigned

points to a missing libname definition, either through metadata or autoexec.sas.

Re: SAS code working properly in Base SAS but not working in Batch mode

chandusaladi — Tue, 01 Nov 2016 09:21:24 GMT

Main purpose of my code is to send the mail alerts when there is an error in the code. here is the error "Libref SBA is not assigned" so it should send the mail and then abort the program. but it is not sending the mail where as the statement that placed after mail statement "abort cancel" statement is executed , even though the statement is in the same macro as mail statement

Re: SAS code working properly in Base SAS but not working in Batch mode

Kurt_Bremser — Tue, 01 Nov 2016 09:30:46 GMT

&syserr is reset at every step boundary, so a successful step in between will prevent your error detection. I'd rather use &syscc for this.

And I see that you want to tolerate WARNINGs. I consider that a VERY BAD IDEA. Programs that do not always end with a return code of zero when they run "successfully" point to sloppy programming and are in dire need of debugging.

Re: SAS code working properly in Base SAS but not working in Batch mode

SASKiwi — Wed, 02 Nov 2016 03:27:17 GMT

Check the SAS options (proc options will do this) of your SAS batch environment. You may find the SYNTAXCHECK option is set:

http://support.sas.com/documentation/cdl/en/lesysoptsref/68023/HTML/default/viewer.htm#n014qbvh3po8w5n1qlqbzr22vtg0.htm

If this is the case then the option OBS = 0 will be set as soon as the SAS error occurs, hence your email DATA step will not produce any output. Try NOSYNTAXCHECK to see if this fixes the problem.

Re: SAS code working properly in Base SAS but not working in Batch mode

chandusaladi — Wed, 02 Nov 2016 06:38:52 GMT

Thank you very much.
now its working after changing the options in the batch server