BookmarkSubscribeRSS Feed
Morse_Bill
Obsidian | Level 7

looking for CAS Actionset.action that corresponds to PROC RANK.  

Is there a "matrix" in the documentation to help with this ? 

2 REPLIES 2
sbxkoenk
SAS Super FREQ

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

DerylHollick
SAS Employee

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;

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 904 views
  • 0 likes
  • 3 in conversation