University of Iowa SAS® Users Group

UISUG was organized in 2008 in an effort to provide SAS® training for University of Iowa staff. The Users Group was formally recognized by SAS® Institute in 2009.


Getting to Know PROC SQL

The SQL procedure can be used to retrieve data from single and multiple tables; select specific data from tables; subset, order, and summarize data; update tables; and combine tables to create new tables and useful reports. It is very powerful as a lot of functions and statements can be included in just one step—which can replace multiple steps of base SAS code.  Join us Monday, April 24th, 2017 from 11:30-12:30 in C217 College of Public Health Building to hear the following presentations:


What is PROC SQL?

An introduction to Structured Query Language (SQL), basic uses in SAS and comparisons to operations in the DATA step.

Syntax for PROC SQL

This presentation will delve further into the syntax of PROC SQL: basic joins, creating views and deriving variables.

Using PROC SQL with Canvas Data

Practical examples using PROC SQL for reporting of Canvas Data and situations when PROC SQL is preferable to DATA step programming.