We have a server with full text searching enabled and another where it is not. We have a stored proc that checks if full text indexing is enabled and runs a search query as appropriate but the issue ...

The RESET statement enables you to add, drop, or change the options in PROC SQL without restarting the procedure. See PROC SQL Statement for a description of the options.

After you assign a libref to a relational DBMS (RDBMS) using the SAS/ACCESS LIBNAME statement, you can reference this new libref in a PROC SQL statement to query, update, or delete RDBMS data. You can ...