Constrain: the number of days per year the sum of the measure is higher then 31.
For 01-01-2016 the sum is equal to 29 (=10+12+7), for 02-01-2016 the sum is equal to 38 (=13+6+9) and for 03-01-2016 is equal to 26 (=5+10+11). So only day 02-01-2016 is more than 30 and met the constrain. And as an output I would like to see the number of days which met the condition which is is in this example.
Do you have any idea how we can calculate this in SAS VA.
Thank you for your reply. I should have been more specific that I need to make this calculation in Report Designer. And there I have access only to a limitted number of functions which select is not one of them. Neither I can use Grouby Date in my calculations! By ''meet the condition'' I mean passing the condition of being greater than 30 in this example.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.