topic Re: SAS VA 7.1 - decreasing sum in SAS Visual Analytics

SAS VA 7.1 - decreasing sum

critters187 — Wed, 22 Nov 2017 05:58:39 GMT

Hi everyone. Is there any way I can get a dataset with a column that has a number that varies row by row (which is a series of dates in the year), to display a total number today, and for each date (let's say there is a date for each week) the 'total' number decreases.

I cannot get the SUM to mathematically work out at all and this is driving me nuts. So in the spreadsheet I have used as an example, I have column A & B in the dataset already loaded in VA. How inside VA do I create column C?

I need to do it in VA to keep the data 'dynamic'. If I 'hard code it' in a spreadsheet and load it to VA, that will defeat the purpose of the report I am trying to create.

Thanks in advance.

Re: SAS VA 7.1 - decreasing sum

Shmuel — Wed, 22 Nov 2017 06:32:32 GMT

I have never worked with SAS VA, but if you can run basic sas then:

1) sort your data by descending date.

2) run a step like:

data temp;
  set have;
        retain total 0;
        total + var_to_sum;
run;

3) sort your data by date (ascending is the default).

Re: SAS VA 7.1 - decreasing sum

critters187 — Wed, 22 Nov 2017 21:50:50 GMT

Thanks Shmuel, I know that will work in SAS EG, but unfortunately it won't work in VA. Appreciate your assistance.