Building Dashboard with Base SAS Institutional Research Experience

Building Dashboard with Base SAS® Institutional Research Experience

• Dashboards are useful tools to draw attention to key metrics. • They can hold a lot of data in summarized fashion. • Drilldown capacity adds levels of details that stakeholders find useful.

• Institutions of higher educations are increasing using dashboards to present some key metrics. • Primary among them: 1. Retention and graduation rates 2. Degrees granted 3. Tuition and cost 4. Faculty and staff 5. Expense 6. Revenue

• Western Oregon University built a six-panel dashboard to present those metrics. • First thing anyone wants to know about a four year college is retention and graduation rates of first-time full-time cohorts. • That includes Board of Trustees, President, Provost and someone like me when I am looking for job as an institutional researcher.

Cohort Table

Cohort Retention and Graduation

Cohort Retention and Graduation Drilldown

Syntax

Six Panel Dashboard

URL Link • data dashboard; • set students; • • URLOrigin. Link_1 = cats("1_Freshman_Retention_Graduation. htm"); • run;

LINKS, LEGENDS AND LEGEND LOCATIONS For multiple cell panels, it may be necessary to avoid repeating legends to save space if charts happen to have common legends. This can be done by inserting the following code after Line 8 in Output 1: rowdatarange=union columndatarange=union and by using syntax for sidebar as follows: sidebar / align=bottom SPACEFILL = _ON_ ; discretelegend 'line 1' 'line 2' 'line 3'/ ORDER = ROWMAJOR across=3 border=off pad=(top=2 px); endsidebar; Slide 7 above is an example of this.

Moving the Legends When charts need individual legends, it’s possible to put those inside the chart to save space, or outside if preferred. It’s also possible to move the legends around to avoid putting them directly over the bars, for example. The following codes are provide an example: discretelegend "Total" "URM" "Men" "Women"/ title="" location=inside halign=right valign=top; endlayout;

Moving the Legends

The Dashboard

Contact Information Name: Abdus Shahid Company: Western Oregon University City/State: Monmouth, OR Phone: 503 -838 -9331 Email: shahida@wou. edu