topic Re: Statements not executed due to NOEXEC option in batch jobs in Administration and Deployment

Statements not executed due to NOEXEC option in batch jobs

SwagatPatil — Tue, 30 Oct 2018 15:31:13 GMT

We are facing issue in proc sql below error in batch jobs.
Statements not executed due to NOEXEC option.
The SAS systems stopped processing this step because of errors.

Is there need to change options in sasbatch.sh or workspace.sh as we are currently migrated to SAS 9.3 to SAS 9.4

Re: Statements not executed due to NOEXEC option in batch jobs

SuryaKiran — Tue, 30 Oct 2018 15:41:12 GMT

I think this is something to do with the code and not any options or something else. Your SQL query might have syntax error or NOEXEC option is set in PROC SQL.

Remove NOEXEC if present.

proc sql noexec;
select * from sashelp.class
;
quit;

Re: Statements not executed due to NOEXEC option in batch jobs

Kurt_Bremser — Tue, 30 Oct 2018 15:41:36 GMT

Statements not executed due to NOEXEC option

is a typical consequence of an ERROR that has sent SAS into syntax check mode (the syntax is verified, but nothing is executed).

Read the log from top down and fix ERRORs/WARNINGs one by one.

Re: Statements not executed due to NOEXEC option in batch jobs

SwagatPatil — Tue, 30 Oct 2018 15:50:02 GMT

I need the second step need to execute if first proc has errors.
I have some control tables that should be update if any error occurs. But if error occurs then next procedures are not executed thats why my control table is not getting updated

Re: Statements not executed due to NOEXEC option in batch jobs

SuryaKiran — Tue, 30 Oct 2018 16:13:37 GMT

What is it your trying to achieve here, trying to run a query if errors exists is not a recommended way. Invoke your query based on the condition that fails the query.

for example:

My below query fails to execute if macro variable values is not assigned.

proc sql ;
select * from sashelp.class
where Age=&Age
;
quit;

I can conditionally run this query

%Macro run_Query();
proc sql ;
select * from sashelp.class
where Age=&Age
;
quit;
%Mend;

%macro isBlank();
 %IF   %sysevalf(%superq(Age)=,boolean) %then %return;
%else %run_Query();
%mend isBlank; 
%ISBLANK();

%symdel age/nowarn;
%ISBLANK();

Re: Statements not executed due to NOEXEC option in batch jobs

SwagatPatil — Tue, 30 Oct 2018 17:27:50 GMT

I need to capture the error , then my control table should some values that indicates my job completed with errors. So it needs to be run below steps to update the control table.

Re: Statements not executed due to NOEXEC option in batch jobs

SuryaKiran — Tue, 30 Oct 2018 17:35:31 GMT

Might be this is what your looking for http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#base-sysop-syntaxcheck.htm