Search notes:
SAS: proc sql
Join algorithms
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
Centered output in the log
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.
See also
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
Index