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.
<see the attachment>
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
Yes. I have monthly return for last 10 years. I have to calculate compunded return for a selected time period in the date slider.
Yes. It is related to finance.
Thanks @Sam_SAS. I will submit this idea. Is there any way to replicate this in Base SAS.
@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.
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
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.