SAS: proc sql

proc sql joins two tables with one of the following four join algorithms:

• nested loop
• sort-merge
• index
• hash join

See also merge join in data step

Apparently, by default, the output-table of a select statement is centered destination (log file).

By setting the nocenter option, the output can be sent to the left side.

select

Insert statement

&sqlobs

alter table

Count missing values

SAS programming: proc

proc sql - execute by

foreign key constraints

not null constraints

expressions

Execute an SQL statement for each observation in a data set

proc sql in conjuction with Oracle:

connect to and connect using.

optimizer

SQL transformations, such as ? to contains etc.

The feedback option shows, what an SQL statement transforms to.

SAS proc sql: describe table