Checks the accuracy of a query-expression's
syntax without executing
- See query-expression .
- The VALIDATE statement writes a message in the SAS log that states
that the query is valid. If there are errors, VALIDATE writes error messages
to the SAS log.
- The VALIDATE statement can also be included in applications that
use the macro facility. When used in such an application, VALIDATE returns
a value that indicates the query-expression's validity. The value is returned
through the macro variable SQLRC (a short form for SQL return code). For
example, if a SELECT statement is valid, the macro variable SQLRC returns
a value of 0. See Using Macro Variables Set by PROC SQL for more
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.