SAS Support Communities

Creating s sorted table in CAS seems to be possible using partioning functionality. You can order variables within a partition. So to create an ordered CAS table, you should create one (dummy) partition for the whole table.    /* Examples how to get an ordered CAS table */ cas; caslib _all_ assign; /* following code uses a 9.4 SAS dataset as input and creates a sorted table in CAS */ data work.unsorted; group = "A"; w1 = 5; w2 = 6; output; w1 = 3; w2 = 3; output; w1 = 1; w2 = 2; output; w1 = 3; w2 = 4; output; run; proc casutil outcaslib="casuser"; load data= "unsorted" casout="sort1" replace partitionby=(group) orderby=(w1 w2) ; run; It's also possible to create a sorted CAS table based on a CAS table as input. This routine could replace a proc sort from 9.4: /* Following code runs in CAS and sorts the columns in a CAS table */ /* A dummy group is added to put all data in the same partition */ data casuser.unsorted; group = "A"; w1 = 5; w2 = 6; output; w1 = 3; w2 = 3; output; w1 = 1; w2 = 2; output; w1 = 3; w2 = 4; output; run; data casuser.sort3 (partition=(group) orderby=(w1 w2)); set casuser.unsorted ; run; You can use this sorted dataset for subsequent datasteps. But: to use constructs like retain and lag() you still have to change the datastep code: you could add the datastep option  / single=yes to force CAS to run the datastep single threaded or use some retain logic to deal with multi threading.   One thing that is not working like it should do: order variables in descending order like in following example: https://documentation.sas.com/?docsetId=casref&docsetTarget=p12eiok32viouqn1huacr2d39nl0.htm&docsetVersion=1.0&locale=en This example contains some syntax errors and is not sorting variable ch as it should do.   My own example to show this: /* following code runs in CAS and should order column w2 descending within column w1 */ /* This is not working as expected: column w2 is not ordered descending within w1 */ data casuser.sort4 (partition=(group) orderby=(w1 DESCENDING w2)); set casuser.unsorted ; run; Why is this not working???       ... View more

Hi Falko,   That's clear to me.    I hope that this will be realized soon because it will make the geo map with clustering a lot more usable.    Cheers, Frank ... View more

But, is there any other way to this? because not all the higher management likes to right click and deselect each time.. can we create another gauge and make an interaction which can bring back to global level when we click on it.. is it possible? ... View more