topic finding similar Viya CAS actionsets.action that correspond to PROCs in SAS Programming

finding similar Viya CAS actionsets.action that correspond to PROCs

Morse_Bill — Tue, 15 Nov 2022 15:18:43 GMT

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

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

Re: finding similar Viya CAS actionsets.action that correspond to PROCs

sbxkoenk — Wed, 16 Nov 2022 21:55:16 GMT

Hello,

What do you want to do with PROC RANK??

I only know about this :

(and nothing about a "matrix")

Actions by Name

Action Sets by Name

Action Sets by Product

Last updated: March 4, 2022

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

Re: finding similar Viya CAS actionsets.action that correspond to PROCs

DerylHollick — Sat, 26 Nov 2022 23:52:09 GMT

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;