proc sql; create table proclib.paylist (IdNum char(4), Gender char(1), Jobcode char(3), Salary num, Birth num informat=date7. format=date7., Hired num informat=date7 ...
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 ...