How to bucketise aggregated measure in SAS VA?

[KarunaTiwari]

Hi All,

I have 2 columns in my data set - Handle Time and Handled Calls.

I am creating an aggregated measure in the front end - AHT = Handle Time / Handle Calls.

Now I want to create Buckets based on Aggregated measure AHT such as

If AHT between 0 and 300, 'AHT Bucket'n = '0-300'

Else If AHT between 300 and 600, 'AHT Bucket'n = '300-600'

Else If AHT between 600 and 900, 'AHT Bucket'n = '600-900'

Else 'AHT Bucket'n = '900+'

Please can anyone help me with how to achieve this.

Regards,

Karuna

[SuryaKiran]

In Data Builder you can write a CASE as you write in PROC SQL under Expression in Column Editor based on your aggregation.  

[SASKiwi]

See my response to the same type of problem here:

https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Visual-Analytics-query/m-p/448517#M9751

Still working on it...