Hi all - my office does performance metrics on employees where they report on the fastest 90% of cases complete. I get the fastest 90% by creating a series of tables: data New;
set PSS.CSBadj;
count+1;
by Adj;
if first.Adj then
count=1;
run;
Proc sql;
Create table PSS.CSBAdj90 as Select Adj, PWPTimeliness, Branch, Team,
max(count) as max_count From work.New Group by Adj Having
count<=(.9*max_count);
Quit; I then use proc tabulate to create a table showing the number of cases and the average timeliness for the fastest 90% per employee. My issue is that if someone only has 1 case, then that Timeliness needs to be reported. Is there any way for me to make the having clause conditional? So that it only applies if max_count>1? Also if there is a better way to go about calculating the fastest 90% or anywhere else I am all ears! Thanks for your help.
... View more
