Hello! I have started a school project with SAS to build a data dashboard which will show information about several workflow processes in a fictional company. The data which is provided is a table which contains employee name, processID, step in the process, starttime, endtime. Unfortunatly I cant open the table outside of my school environment to show it here. The goal is to measure performance of the employees. One of the KPI's of the resulting dashboard should be the percentage of employees who perform processes with the correct sequence of steps. Example workflow process: Helpdesk support issues For this process there are 2 correct sequences of steps: 1) select issue -> open -> check current status -> close 1) select issue -> open -> check current status -> call customer The first sequence is close if the current status = in progress. The second sequence is finished with calling the customer if the current status = new. The example above is the most simple process in the table (the percentage should be around 100% for this process), but this was just to elaborate my problem. Since this is my first time using SAS, I dont know how I can "let SAS know" what the correct sequence of steps is. After that I can calculate the percentage to use in the dashboard. How can I code this in SAS? What would be a good way to implement this using SAS? Thanks for your time!
... View more