topic Re: Calculating Product for a period/selected observations of a variable in SAS Visual Analytics

Calculating Product for a period/selected observations of a variable

ksachar — Fri, 24 Feb 2017 20:23:48 GMT

I WANT:

I want the report users to have the capability to calculate the Product of obs in Variable VALUE based on the MONTH_END_DATE selection.

I HAVE:

Let's say I have a slider with MONTH_END_DATE value in it which gives a user the flxeiblity to choose a period. Once they have choosen a begining and ending period of their choice, I want to display the product of all observations for variable VALUE.

For example: User select JAN2015-MAR2015 in the slider, I want to display Product of the 3 obs in that period (0.988*1.035*.995)

1.0174

It can be done very easily in Excel, Is there a way to do it in VA.

Re: Calculating Product for a period/selected observations of a variable

Sam_SAS — Mon, 27 Feb 2017 15:44:35 GMT

Hello,

If I understand correctly, you want basically want an aggregation type that multiplies the values together in the same way that the SUM aggregation adds the values together.

Is that right?

I don't think there is a way to do this currently. Can you explain the scenario where this type of calculation is needed?

Thanks,

Sam

Re: Calculating Product for a period/selected observations of a variable

ksachar — Mon, 27 Feb 2017 16:31:04 GMT

Yes. I have monthly return for last 10 years. I have to calculate compunded return for a selected time period in the date slider.

Re: Calculating Product for a period/selected observations of a variable

Sam_SAS — Mon, 27 Feb 2017 16:38:34 GMT

Thanks for your reply.

I don't know much about such things, but if I understand correctly this is a banking / finance application?

Thanks,
Sam

Re: Calculating Product for a period/selected observations of a variable

ksachar — Mon, 27 Feb 2017 17:34:25 GMT

Yes. It is related to finance.

Re: Calculating Product for a period/selected observations of a variable

Sam_SAS — Mon, 27 Feb 2017 17:54:50 GMT

Ah, thanks.

If you could submit this as an idea here:
https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas/label-name/sas%20visual%20analytics

It would help our product management evaluate the feature for a future release.

Thanks,
Sam

Re: Calculating Product for a period/selected observations of a variable

ksachar — Tue, 28 Feb 2017 17:19:58 GMT

Thanks @Sam_SAS. I will submit this idea. Is there any way to replicate this in Base SAS.

Re: Calculating Product for a period/selected observations of a variable

Sam_SAS — Tue, 28 Feb 2017 17:28:10 GMT

Great! That really helps us. If you could give some more details about your business needs for this feature it helps our team evaluate whether this feature should be prioritized.

About Base SAS, I would expect that it is possible do this in Base SAS but I couldn't say offhand how to do it.

Re: Calculating Product for a period/selected observations of a variable

ksachar — Mon, 20 Mar 2017 17:46:43 GMT

@Sam_SAS I was able to resolve it using Base SAS. I have updated the idea for future product developements. If you are interetsed I can walk you through my requirement and show you how I resolved it.

Re: Calculating Product for a period/selected observations of a variable

Sam_SAS — Mon, 20 Mar 2017 17:55:51 GMT

That is good to hear!

I looked for your idea but I can't seem to find it. Can you post a link?

It would be best for us if you could post your requirements and your workaround there.

Thanks,

Sam

Re: Calculating Product for a period/selected observations of a variable

ksachar — Mon, 20 Mar 2017 19:12:18 GMT

@Sam_SAS Here is the link:

https://communities.sas.com/t5/SASware-Ballot-Ideas/Aggregated-Product-by-Group-in-SAS-Visual-Analytics/idi-p/342708

Re: Calculating Product for a period/selected observations of a variable

Sam_SAS — Mon, 20 Mar 2017 19:18:54 GMT

Thanks, I can see it now and I am also able to find it when I browse the VA ideas.