sas data studio aggregation(sum) function

ggunes — Tue, 26 Oct 2021 11:21:36 GMT

Hello everyone,

I want to ask you a question about a subject that I have been dealing with a lot.

I have a table like this:

segment	group	date	actual
A	a	Jun-21	3
A	a	Jun-21	5
A	b	Jul-21	7
A	c	Aug-21	8
B	e	Sep-21	4
B	e	Sep-21	6
C	d	Nov-21	2
C	d	Nov-21	5
C	f	Jan-22	7

I want to sum actual values of same segment,same group, same date like this:

segment	group	date	actual
A	a	Jun-21	8
A	b	Jul-21	7
A	c	Aug-21	8
B	e	Sep-21	10
C	d	Nov-21	7
C	f	Jan-22	7

How can I do that in Data Studio(Prepare Data). I couldn't do this with any transform option and also "code" option in "custom transform" options.

I would be very grateful if someone could help.

Thanks.

Re: sas data studio aggregation(sum) function

EyalGonen — Sun, 05 Dec 2021 11:52:43 GMT

Hi @ggunes

I am not a Data Studio expert but my guess is if no built-in transform allows it, then you can always fallback to using the "custom code" node with CASL language and summarize the data like shown here: https://blogs.sas.com/content/sgf/2019/08/08/summarization-in-casl/

Eyal

topic sas data studio aggregation(sum) function in SAS Procedures

sas data studio aggregation(sum) function

Re: sas data studio aggregation(sum) function