I have a start and end date in my data set. I calculated a new item called "number of days" as the number of days in between these two dates. I also calculated the average number of days using the median which is 59. Now, I would like to count how many of my records are above the average number of days and how many are below the average. What would be the calculated item formula for it? For example, assuming I have these 5 records on my dataset:
Number of Days 110 100 45 55
Then, my new calculated item "above average" would have the value 2. and My new calculated item "below average" would have the value 3. So, I could create a key value objects using these values as the measure.
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.