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;
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.
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.
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();
Might be this is what your looking for http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#base-sysop-syntaxch...
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.