You already
know that you can use the EXEC | NOEXEC option to specify whether
a statement should be executed after its syntax is checked for accuracy.
If the EXEC option is in effect, SAS checks the PROC SQL syntax for
accuracy and, if no error is found, executes the SQL statement.
The ERRORSTOP | NOERRORSTOP option specifies whether
PROC SQL stops executing if it encounters an error. This option is
useful only when the EXEC option is in effect. The default is ERRORSTOP
in batch or in a noninteractive session and NOERRORSTOP in an interactive
SAS session.
ERRORSTOP instructs
PROC SQL to stop executing the statements but to continue checking
the syntax after it has encountered an error. ERRORSTOP has an effect
only when SAS is running in batch or in noninteractive execution mode.
NOERRORSTOP instructs
PROC SQL to execute the statements and to continue checking the syntax
after an error occurs. NOERRORSTOP is useful if you want a batch job
to continue executing SQL procedure statements after an error is encountered.