topic Re: How do you create cumulative values in Expression Builder in Ent Guide? in SAS Enterprise Guide

How do you create cumulative values in Expression Builder in Ent Guide?

deleted_user — Tue, 05 Aug 2008 18:35:31 GMT

I am struggling with trying to create a computed column that calculates the cumulative values of another column. This does not seem like it would be a difficult task, however, there does not appear to be a function that does this. Does anyone know of a function, or some trick in order to generate cumulative values within enterprise guide?

Re: How do you create cumulative values in Expression Builder in Ent Guide?

Doc_Duke — Tue, 05 Aug 2008 19:04:36 GMT

Actually, this is one of the things that are hard to do in PROC SQL and I'm not even sure that it can be done. You are asking to do a running total and that requires an assigned order to the data. SQL is designed to be done without any order while it is working.

This is easy to do in a data step, but that requires a code task.

Doc Muhlbaier
Duke

Re: How do you create cumulative values in Expression Builder in Ent Guide?

deleted_user — Thu, 07 Aug 2008 21:33:51 GMT

I was able to figure this out for anyone who is interested in knowing.

data work.NewTableName;
set work.TableYourFieldisIn;
'NewCumulativeColumnName'n + 'FieldForCumulativeColumnToSum'n;
run;

This will put out a new table containing the information from your reference table as well as your new cumulative column.

Re: How do you create cumulative values in Expression Builder in Ent Guide?

deleted_user — Thu, 07 Aug 2008 21:34:44 GMT

Oh yeah, i forgot to mention that the above entry can be done in a "Code Step" in EG

Re: How do you create cumulative values in Expression Builder in Ent Guide?

anzabob — Wed, 06 Oct 2021 14:11:07 GMT

Hahaa thanks this still helped me 13 years later 😄