A common type of join is an equijoin, in which the values from a column in the first table must equal the values of a column in the second table. PROC SQL can process a maximum of 32 tables for a join ...

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 ...