Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How to bucketise aggregated measure in SAS VA?

Reply
Contributor
Posts: 37

How to bucketise aggregated measure in SAS VA?

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

PROC Star
Posts: 629

Re: How to bucketise aggregated measure in SAS VA?

Posted in reply to KarunaTiwari

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

Thanks,
Suryakiran
Super User
Posts: 4,019

Re: How to bucketise aggregated measure in SAS VA?

Posted in reply to KarunaTiwari

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...

 

 

Ask a Question
Discussion stats
  • 2 replies
  • 135 views
  • 0 likes
  • 3 in conversation