SAS PROC SQL: Read an entire data set and output to the screenSAS Output: List of Store EmployeesSAS PROC SQL: Read specific variables from a data setSAS Output: First and Last Names of Store EmployeesSAS PROC SQL: Filter data resultsSAS Output: Store Employees with the Surname WilsonSAS PROC SQL: Filter data results by matching on multiple variablesSAS Output: Store Employees in the Media station with the Surname WilsonSAS PROC SQL: Filter data results using negative matchingSAS Output: Store Employees that do NOT have the Surname WilsonSAS PROC SQL: Filter data results using a list of valuesSAS Output: Store Employees in the Computer or Media stationSAS PROC SQL: Read an entire data set and output to a new data seSAS Data Set - Replica of Staff table

SQL for SAS Programmers – Part 1 – Extracting Data

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”): (download) SAS Code for Tutorial Part 1 (download) SAS...

April 14th, 2009 by Blink 7 
Add Comment
Read More...
Full Post

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

April 12th, 2009 by Blink 7 
Add Comment
Read More...