Assigning values for multiple deciles

[aredman]

Hello all,

I am in the process of trying to assign values to my decile figures but seem to have a problem. I need to set max and min limits for each decile. Any help is appreciated.

ex:
sel
TRAN_NBR
,quantile (5, TRAN_NBR) as Decile

from
DQ_1DAY

When I run this my decile results are too sporadic.

Thanks

 

[dnoeth]

If you really want to assign your own limits then you'll have to use a CASE:

sel
TRAN_NBR
,case
when TRAN_NBR < 222 then 1
when TRAN_NBR < 444 then 2
when TRAN_NBR < 555 then 3
when TRAN_NBR < 999 then 4
else 5
end
from
DQ_1DAY

Dieter