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
The first part of this tutorial deals with using the PROC SQL statement to perform basic data extraction. Screenshots of the code and output are included. Readers who wish to follow along on their own systems or copy the code can download the files provided below (right click and select “save as” or “save link as”):
read more at:....
(download) SAS Code for Tutorial Part 1
(download) SAS Data: Transactions
(download) SAS Data: Payment Types
(download) SAS Data: Staff
Comparing SAS steps and PROC SQL_ Coding and Performance -
Basics of SAS PROC SQL -