The 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.
Upcoming Trainings
The University of Iowa SAS® Users Group invites you to attend an instructional seminar on the SAS® macro language and PROC SQL. SAS® expert, Rebecca Callaway, will give two presentations on October 3, 2025.
11:00-12:00
SQL and Macro 101
N120, College of Public Health
This presentation is for users wishing to learn the syntax basics for PROC SQL and the SAS Macro language. PROC SQL is a powerful query language that can sort, subset, join and print results all in one step. The SAS Macro Facility can be leveraged to make your programs more dynamic and maintenance-free. Users who are continuously improving their analytical processing will benefit from this seminar. Participants will learn the following elements of PROC SQL: understand the syntax order in which to submit queries to PROC SQL; Select and calculate columns; Filter Rows; summarizing data; Joining tables using join conditions like inner joins and outer joins. This session also includes an introduction to the SAS Macro facility.
12:00-1:00
Light Lunch
C217, College of Public Health
1:00-2:00
2-for-1 SQL & Macro Techniques SAS Seminar
N120, College of Public Health
PROC SQL and the Macro language are some of the most frequently used techniques by advanced SAS users. PROC SQL is an ANSI standard query language that can manipulate data and print results all in one step. The SAS macro language is a very versatile and useful tool. It is often used to reduce the amount of SAS code, and it facilitates passing information from one procedure to another procedure. Furthermore, we can use it to write SAS programs that are “dynamic” and flexible. Participants will learn the following elements: How to create macro variables; How to use macro variables for text substitution; How to use PROC SQL to create macro variables.
These presentations are open to everyone. Please register if you can and pass the word around about the meeting to your colleagues.
There will be a drawing for door prizes following each presentation. Must be present to win.
This event is sponsored by UI Human Resources, College of Public Health, College of Nursing, and Information Technology Services.
If you have questions, please contact Sarah L Bell.