SAS Institute in Cary has graciously agreed to host the NCAIR Summer Drive-In on 7/26 from 10-3. A special thank you is in order because they are not yet open to the public. Thank you, SAS.

A wide variety of topics are available: SAS macro tricks, Data Ethics, Excel tips & tricks, state of IR/IE from AIR’s national perspective, Power BI dashboard development, an update on IPEDS, and more; see Additional Information below. Attendance is limited to 38 people as SAS is not fully open to non-employees. Registrations are on a first-come, first-served basis. Registration is closed – the event is at capacity.

Protecting your Health and Safety

Before registering, please be aware that only COVID-vaccinated people may participate in the event. That means the typical two-shot sequence, with boosters optional. If you have COVID symptoms or a positive test between July 15 and July 26, please let NCAIR know so we can offer your spot to the next person on the waitlist. Masks and distancing are optional during the event; please use your own discretion and judgment. Thank you in advance for your help in keeping everyone safe.

Basic Logistics

Free parking is available at SAS. Lunch is available for approximately $15 in SAS’ highly regarded cafeteria, which is within walking distance from the event space. The cafeteria only accepts payment via debit or credit – no cash.


The event is free to current NCAIR members. If you attended the conference on April 7th and paid your $25 membership, you are a current member. Otherwise, you can renew your membership online now, and pay by check or by using PayPal as instructed on the renewal form.

Registration is now closed, as the event is at capacity. Thanks for your interest in NCAIR’s events.


Additional Information

This page will be updated with agendas, logistics, and additional information as the event approaches — please bookmark this page for later reference. If you need to rescind your registration due to unforeseen events, please notify Kelly Smith and Andrew Walker, so that a person on the waitlist can attend.

Parking and Entrance Information

  • Please use the Harrison Avenue entrance and check in with Security, who will have your names and allow you entry onto campus.
  • Driving directions from the SAS main entrance to the GEC / Building A are attached to this page. (Scroll to the bottom of this page to download and print it.)
  • There is reserved customer parking in front of the Global Education Center (GEC), which is Building A, for your convenience.
  • Please place the attached parking placard on your dashboard. (Scroll to the bottom of this page to download and print it.)
  • Your Meeting Host will greet you at the front entrance of Building A, the GEC, and escort you to the training rooms.
  • You can click this link for driving Directions and a SAS Campus Map.

2022 SAS Summer Drive-In Full Agenda

Session Descriptions

Data Ethics
Data ethics, or deciding the “right” things to do in data handling, reside firmly in the intersection between Institutional Research and Data Governance. This presentation will focus on tenets and principles available to help guide the judgment of IR professionals in data handling as well as examples of steps that East Carolina University has taken to foster ethical use of data. Time will be allotted at the end of the presentation for attendees to share examples from their own campuses.
IPEDS Update
This session will provide a general update on the Integrated Postsecondary Education Data System (IPEDS) annual survey collected by the National Center for Education Statistics (NCES) of the U.S. Department of Education. The focus of the session will be on the proposed changes to the upcoming 2022–23 and 2023–24 collections. Also highlighted will be recent R&D activities and new IPEDS resources.
SAS Macro Tricks
Want to create more efficient and effective base SAS programs? The session covers programming situations where macro variables and programs can solve data challenges, create more efficient programs, and reduce the likelihood of data entry errors. Macro solutions are demonstrated through an example/cookbook style approach.
PresentationSupporting SAS Code
Insights from AIR’s 2021 National Survey of IR Offices
This session will highlight findings and trends from the Association for Institutional Research’s 2021 National Survey of IR Offices, including IR office structures, leadership, resources, and effectiveness. The project, which began in 2015, seeks to better understand and improve IR office operations. The results will be discussed in light of current challenges and opportunities facing the IR/IE profession and higher education overall.
SAS Institute – Topic 1
How do you manage your SAS projects with GIT? by Chris Hemedinger
Are you asked to use source management and DevOps tools to manage your work and integrate with production? Git – the most popular source-management system – is often central to this integration. During this webinar, I discuss SAS integration with Git for collaborative projects in your teams including 1) how Git’s foundation fits in the development process, 2) which ways SAS integrates with Git and Git-based tools, and 3) how to add a SAS project, including code and other assets, to Git for collaboration.
SAS Institute – Topic 2
ODS: It’s Not Just for Tables Anymore. Using Formatted Text and Lists in Your Reports. by Scott Huntley
You’re used to seeing tables in your ODS reports, but maybe you need that extra something to drive your results home. Did you know that you can add formatted text and lists to your report? With PROC ODSLIST and PROC ODSTEXT, you can add richer descriptions to your reports, or even generate data-driven lists and blocks of text.
Excel Tips and Tricks
This seminar is designed to showcase little-known Excel tips and tricks, with the goal of helping participants work more quickly and accurately in Microsoft Excel. The seminar will start out with generic tips that appeal to everyone who generates spreadsheets and will cover intermediate and advanced tips and tricks as the seminar progresses.
This seminar provides an introductory understanding of Power BI Desktop data collection, manipulation, and visualization. Objectives:  review the power BI environment,  connecting to text files, worksheets, and database files, cleaning and manipulating data, and an introduction to Power BI data visualization.
[gview file=””] [gview file=””]