topic Re: How to bucketise aggregated measure in SAS VA? in SAS Visual Analytics

How to bucketise aggregated measure in SAS VA?

KarunaTiwari — Mon, 26 Mar 2018 17:41:33 GMT

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 — Mon, 26 Mar 2018 18:07:32 GMT

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

SASKiwi — Mon, 26 Mar 2018 20:02:16 GMT

See my response to the same type of problem here:

Still working on it...