PROC SQL Basics
Overview
PROC SQL is the SAS implementation of Structured Query
Language (SQL), which is a standardized language that is widely used
to retrieve and update data in tables and in views that are based
on those tables.
The following chart
shows terms used in data processing, SAS, and SQL that are synonymous.
The SQL terms are used in this chapter. A SAS data set (or SAS data
file) can be a table or a view.
|
SAS
|
SQL
|
|
|---|---|---|
|
file
|
SAS data file
|
table
|
|
record
|
observation
|
row
|
|
field
|
variable
|
column
|
PROC SQL can often be
used as an alternative to other SAS procedures or the DATA step. You
can use PROC SQL to do the following:
-
retrieve data from and manipulate SAS tables
-
add or modify ...
Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
