You create PROC SQL tables from SAS data files, from SAS data views, from relational DBMS tables using the LIBNAME statement, or from relational DBMS tables using the SQL Procedure Pass-Through ...
The SQL Procedure Pass-Through Facility is an extension of the SQL procedure that enables you to send DBMS-specific statements to a DBMS and to retrieve DBMS data. You specify DBMS SQL syntax instead ...
Yes a sproc can return multiple resultsets and you can even work with them in ADO, though it is somewhat esoteric.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback