Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...

Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

The following example searches the SQL DICTIONARY.CATALOG rows for the SASUSER library and PROFILE catalog to find all catalog types of QUERY (saved SQL Query window queries). The name and description ...