Statements not executed due to NOEXEC option in batch jobs

[SwagatPatil]

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

[SuryaKiran]

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;

[Kurt_Bremser]

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.

[SwagatPatil]

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

[SuryaKiran]

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();

[SwagatPatil]

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.

[SuryaKiran]

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