The Power of Automating Processes: Enrollment Projection From Excel to SAS

Session Abstract: Process automation helps Institutional Research offices support data-informed decisions by improving efficiency and standardizing the approach to high-priority, repeated data requests. In this session, explore the automation project one Institutional Research office used to turn a manual, Excel-based enrollment projection into a SAS®-based process that begins with automated data pulls and ends with predetermined reporting output. Takeaways include lessons learned on project management, connecting with external databases, translating decision points into code, and designing automated report formats.

Keywords: project management, enrollment projection, process automation