The SQL procedure does not generate a note when the NOFMTERR system option is in effect and when a format or an informat is not found


When the system option NOFMTERR is in effect, a note is written to the log (rather than an error message) if SAS® does not find a format or an informat.

A note is written to the log when the NOFTMERR option is in with a DATA step, but a note is not written when NOFMTERR is in effect with PROC SQL.

In both cases, the missing format is replaced with the w. or the $w. default format, and the processing continues.

Currently, there is no workaround or solution for this problem.