PROC SQL

GPTKB entity

Statements (52)
Predicate Object
gptkbp:instanceOf SAS procedure
gptkbp:accessibleBy gptkb:Oracle_databases
ODBC data sources
CSV files
PostgreSQL databases
external databases
SAS datasets
Teradata databases
SQL Server databases
MySQL databases
DB2 databases
remote databases
gptkbp:canBe gptkb:SAS_DATA_step
gptkb:transformation
subqueries
data extraction
data cleaning
data summarization
data filtering
data reporting
aggregate functions
data merging
SAS functions
SAS libraries
SAS macros
set operators
user-defined formats
gptkbp:canCreate tables
indexes
views
macro variables
gptkbp:canGroupBy columns
gptkbp:canOrderBy columns
gptkbp:canSummarize data
gptkbp:documentation SAS official documentation
https://www.w3.org/2000/01/rdf-schema#label PROC SQL
gptkbp:implementedIn SQL
gptkbp:introducedIn SAS 6.0
gptkbp:output reports
SAS datasets
gptkbp:participatedIn multiple tables
gptkbp:supports SELECT statement
DELETE statement
INSERT statement
UPDATE statement
gptkbp:usedFor report generation
data manipulation
data querying
data definition
gptkbp:usedIn gptkb:SAS
gptkbp:bfsParent gptkb:SAS_SQL
gptkbp:bfsLayer 8