Greetings everyone,
So, I have been asked to provide in a single crosstab and accompanying graph(s) for the following scenario
an overall success rate for an entire division,
an overall success rate for an entire Department,
an overall success rate for an entire Program,
an overall success rate for an entire course,
and then a specific faculty members success rate for the course(s) they have taught.
The faculty member's information comes from a dataset/LASR table of all faculty at the college and their individual success rates, but the faculty member viewing the SAS VA report only sees their information.
I do not believe this is possible if for no other reason than information being displayed is filtered by each subsequent area thus eliminating the possibility of calculating metrics for an overall data point. I am wondering if there is a some functionality that would allow the combining of data such as the overall metrics from multiple sources with the table using row level security?
The attached PDF is an idea of what the users are looking for.
The "My Courses" bar would be the specific faculty member success rate for the course(s) they taught for a given term and year.
The "All CHM1025" and "ALL CHM2046" are the overall success rates for those courses for a given term and year.
The "Chemistry" bar is the Department success rate for all courses in the given Department for a given term and year.
The "Nat Science" is the Program success rate the given Department for the given term and year.(Division isn't included here, but would be another bar titled "Liberal Arts & Sciences))
I can create each of the metrics as individual crosstabs and line /bar charts, but the users are looking to have all of this information in one crosstab and graph.
Thank you as always for your help.
Regards,
Gary
Hi @ghartge,
if showed an example of your given data (row with titles and one data row), I would give it a try.
Best Markus
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.