looking for CAS Actionset.action that corresponds to PROC RANK.
Is there a "matrix" in the documentation to help with this ?
Hello,
What do you want to do with PROC RANK??
I only know about this :
(and nothing about a "matrix")
And this :
CAS Actions and Action Sets - a brief intro
By Peter Styliadis on SAS Users August 6, 2021
https://blogs.sas.com/content/sgf/2021/08/06/cas-actions-and-action-sets-a-brief-intro/
Cheers,
Koen
The topk or groupby actions do some basic ranking.
data casuser.cake;
input Name $ 1-10 Present 12-13 Taste 15-16;
datalines;
Davis 77 84
Orlando 93 80
Ramey 68 72
Roe 68 75
Sanders 56 79
Simms 68 77
Strickland 82 79
;
proc rank data=casuser.cake out=order descending ties=low;
var present taste;
ranks PresentRank TasteRank;
run;
proc print data=order;run;
proc cas;
simple.topk result=r1 / table={name="cake"}
inputs={"Name"}, topk=7, bottomk=0, includeMisc=FALSE, weight="Present";
simple.topk result=r2 / table={name="cake"}
inputs={"Name"}, topk=7, bottomk=0, includeMisc=FALSE, weight="Taste";
print r1 r2;
quit;
proc cas;
simple.groupby result=r3 / table={name="cake"}, inputs={"Name"}, weight="Present", descending=TRUE;
simple.groupby result=r4 / table={name="cake"}, inputs={"Name"}, weight="Taste", descending=TRUE;
print r3 r4;
quit;
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.