Proc SQL for SAS Programmers
SQL for SAS Programmers - Introduction
What is SQL?
SQL stands for Structured Query Language and was designed for development and maintenance within a Database Management System (DBMS). A DBMS consists of one or more tables of data, typically joined in a hierarchical fashion, and a series of programs for organizing the data.
Typical tasks performed with SQL code include the following:
Retrieve (or query) data from one or more data tables
Manipulate data within existing tables
Define new tables and create data within new table
Alter existing table definitions
Set permissions for different users to access existing tables