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

The following drop statement results in a ERROR: A rename/delete/replace attempt is not allowed for a data set involved in a referential integrity drop table tq84_child; quit; /* So, the foreign key ...

About Attempts to drop columns using proc sql without alter table Readme Activity 0 stars ...

The DICTIONARY tables component is specified in the FROM clause of a SELECT statement. DICTIONARY is a reserved libref for use only in PROC SQL. Data from DICTIONARY tables are generated at run time.

Proc sql can also use the implicit pass-through feature, which automatically converts your SAS data set references to SQL tables and sends them to the external database server.