As you use the PROC SQL statements
that are available in the pass-through facility, any error conditions
are written to the SAS log. The pass-through facility generates return
codes and messages that are available to you through the following
two SAS macro variables:
contains the data source
return code that identifies the data source error.
contains descriptive
information about the data source error that is generated by the data
source.
The contents of the
SQLXRC and SQLXMSG macro variables are printed in the SAS log using
the %PUT macro. They are reset after each pass-through facility statement
has been executed.