I have created an aggregated measure and i want to create a Bucket Interval for example = '300 - 500' , '501 - 700' so on using that aggregated measure. I am not able to use aggregated measure directly to create it. Also I can't perform this calculation in data preparation because dynamic calculation require.
Is there any way to perform it or alternative please let me know?
In Data Builder you can write a CASE as you write in PROC SQL under Expression in Column Editor based on your aggregation.
Thanks For your support
I already tried with your approach but It is not giving a dynamic bucketing, Like in aggregation whenever the selection filter applies it aggregate on the same. But when I am creating it in data preparation in EG or In data builder it does not group dynamically. For example in data builder-
(TalkTime + HoldTime + WrapTime)/HandledCall it aggregate on the individual row basis and gives default sum which does not give the dynamic Bucketing ,It calculate on a static table, The dynamic calculation only be performed in aggregated Column. Hence creating a bucket in data builder and in calculated column in va gives same result.
Can you elaborate your problem with some sample data you have and what you want
Thanks support
But as with aggregated measure Category bucket cant be created my problem is not solved. On data level I may apply some alternative but still dynamically cant be change group bucket.
Here I am attaching a example Excel sheet table as per the requirement.
Well after some considerable thought, the only way I can think of getting this to work is to pre-summarise the data across your one, two, three categories. Then when you load the data into VA you can change your aggregated measure to just a measure as it now can be dealing with only one row of data instead of multiple rows. A non-aggregated measure can be used in a custom category.
Of course, this isn't going to work if you want to have a different level of aggregation like just say your categories one and two. Possibly you could explore the idea of creating a different data source for each level of aggregation but that is starting to sound messy.
BTW, what type of VA report are you using this data in?
Maybe there are some more experienced VA users out there you can think of a smarter approach.
I would normally use a custom category for this type of problem, but when I tried this it appears you can't use aggregated measures in a custom category, at least not in VA 7.4. Another option for bucketing is a user-defined format, but you can only apply those to existing data items, not calculated items that exist only in VA.
Perhaps if you can explain your aggregated measure in more detail including the level of aggregation we might be able to think of something.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.