Friday, July 30, 2010
10:00 AM – 3:00 PM
SAS® Institute Campus, Cary, NC
Our last Summer Drive-In, held on the campus of the SAS® Institute in Cary, NC, was very well attended and there were many positive comments about the workshops (and the food!), so we decided to approach SAS® again about hosting NCAIR. They graciously agreed, so we’ll head to Cary once again this summer. Here are details:
Morning Workshops: 10 AM – Noon
Morning Option 1: Accessing Oracle and Microsoft Excel Data Using SAS®
Learn how to use the SAS/ACCESS engines to connect to your Oracle data (such as Banner) as well as Microsoft Access. We’ll use the LIBNAME statement to connect directly to the underlying data and read the data with a DATA step and SAS® procedures.
Morning Option 2: Using Microsoft Excel® Pivot Tables to Turn Institutional Data into Institutional Knowledge
This workshop will provide insight into using the pivot table feature in Microsoft Excel® to quickly analyze and consolidate large amounts of data from your institutional data sources into informative reports. The workshop will also provide tips on how to track and analyze trends with your institutional data. The workshop will provide hands-on training with Microsoft Excel® using a provided sample data set. Presented by Scott Jenkins, NC A&T State University.
Lunch held on SAS® Institute Campus
Afternoon Workshops: 1:00 PM – 3:00 PM
Afternoon Option 1: Using PROC SQL to Explore Your Data Using SAS®
This workshop demonstrates how to use PROC SQL and other BASE SAS procedures (FREQ, MEANS) to explore and manipulate your returning freshmen data. We incorporate the NSSE survey and formats.
Afternoon Option 2: DIY Dashboards in Excel®: An Introductory Workshop
At the 2010 NCAIR Conference, we took a brief look at Do-It-Yourself Dashboards in Microsoft Excel®. Now it’s time to get our hands dirty! After a brief review the DIY Dashboard basics, we’ll dive into some hands-on exercises and familiarize ourselves with the various skills needed to create dashboards in Excel®. By the end of the workshop, all participants will have had the opportunity to develop their very own personalized dashboards. Everyone is encouraged to bring their own data sets (with care of confidentiality issues, of course) to work with in the computer lab. Presented by Ryan Sparrow, Duke University.