topic Re: Do SAS Intelligent Decision have distinct/group by function for datagrid? in Decisioning

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

Mayt — Wed, 25 Sep 2024 09:11:56 GMT

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!!

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

LinusH — Wed, 25 Sep 2024 10:45:03 GMT

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?

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

Mayt — Wed, 25 Sep 2024 11:50:51 GMT

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.