Making Buckets for the following using class or intervalmatch ?

[Anonymous]

Hi ,

  Here year is depicted as 0.5,  0.75 ,1   ,1.25.....so on till 57 years.

I want to build a bucket where values that fall between 0 to 1yrs should fall in the bucket 1. and 1.25 to 1.50 should fall in the bucket 1.5 ..1.51     and 2 should fall in the bucket 2..so on.

I know this can be done using if condition followed by creating a mapping table. But this method is cumbersome ..as I have to write if condition till 59 years.

Is there a easier way of doing this  ( I'm sure it can be done using interval match or class funtion )

And how to convert the value 1.25 to 1 year 3 months .

Balraj

[whiteline]

Hi.

Class function gives you an equidistant buckets so this is not the case.

Create a table with boundaries and use interval match.