SAS/ACCESS Software for Relational Databases: Reference

What Are PROC SQL Tables?

A PROC SQL table is synonymous with a SAS data file and has a member type of DATA. You can use PROC SQL tables as input into DATA steps and procedures.

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 Facility. The SQL Procedure Pass-Through Facility is described in SQL Procedure Pass-Through Facility.

In PROC SQL terminology, a row in a table is the same as an observation in a SAS data set. A column is the same as a variable.

Note: In this chapter, the term table refers to PROC SQL tables, relational DBMS tables, SAS data files, and relational DBMS views unless otherwise noted. [cautionend]

Chapter Contents
Previous
Next
Top of Page