proc sql;
select pid, role, monotonic() as help
from demo
group by pid
having help = min(help)
;
quit;
run;
Test if you can achieve your goal with the code above. For some background read: https://communities.sas.com/t5/SAS-Communities-Library/MONOTONIC-function-in-PROC-SQL/ta-p/475752.
... View more
