Friday, November 20, 2009

Proc SQL for SAS Programmers

Yesterday I came across a website BLINK7. It is a great site to browse and to get help to improve your SAS knowledge in Proc SQL and Base SAS. This website offers a lot of information in the form of sample codes and tutorials on different topics in SAS.

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

SAS Tutorial: Creating Categories with PROC FORMAT

SAS Tutorial: Loading Tab-Delimited Files


Comparing SAS steps and PROC SQL_ Coding and Performance -

Basics of SAS PROC SQL -


Post a Comment