Do SAS Intelligent Decision have distinct/group by function for datagrid?

[Mayt]

Hi everyone!!

I want to use distinct/group by function for datagrid in SAS intelligent Decision. But I found only datagrid_distinctrowcount function  which merely return the number of unique rows in the specified data grid. If you guys have any recommendation, please let me know. Thank you in advanced!!

[LinusH]

I'm not a user of Intelligent Decision, but reading the doc it seems all functions applies to a whole dat grid.

What would you expect to be the outcome by using a Group By?

[Mayt]

well, in the document i provided earlier it's about counting distinct row in table. I tried using it and it returned a count of distinct row, but the datagrid still have the same data as before being distincted.

And for group by function, I want to use it when it come to aggregate scenario.