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 ...